user: ### NOW ANSWER:
Question: How many people in the total region when there are more than 6406 in Fitzroy, 27017 in Livinstonge, and less than 58382 in Rochhampton?
Columns: ['Year', 'Total Region', 'Rockhampton', 'Livingstone', 'Fitzroy', 'Mt Morgan']
Types: ['real', 'real', 'real', 'real', 'real', 'real']
Sample row: [1933.0, 44501.0, 29369.0, 6472.0, 4256.0, 4404.0]
SQL:

assistant: SELECT COUNT("Total Region") FROM "Table" WHERE "Fitzroy" > 6406.0 AND "Livingstone" = 27017.0 AND "Rockhampton" < 58382.0;