How to write result of a query to more than 1 .csv

Shell Programming and Scripting
1

If the result of the query is greater than say, 50,000 then the next 50,000 should be written to the second file and so on. Is it possible?

2 
your query command |split -l 50000