How to write a SQL query in MySQL Workbench and from where I can see the resulting table?

Transcribed Image Text:

Write a SQL query to calculate total population, average percentage of white, black, and Asian population, average income per capita, and average median rent, by states. Sort by total population in descending order. The resulting table may look like: State California Texas New York Florida Pennsylvania Illinois Ohio total_population 37659181 25639373 19487053 19091156 12731381 12661727 11549590 Michigan 9886095 Georgia 9810417 North Carolina 9651380 1 avg_percent_white avg_percent_black avg_percent_asian avg_income avg_rent 27255.2759 932.9138 22813.8110 478.2008 27608.3710 691.6290 22904.4328 665.4478 25173.2985 551.2537 25223.0795 493.9659 23542.8068 498.6932 22830.2530 519.6867 20093.7736 480.2453 22042.2800 505.6600 56.5000 58.4724 82.3548 69.3433 89.5224 87.3636 91.0000 88.8554 63.5409 68.8000 3.1034 6.2323 5.7419 14.0896 4.2388 4.9432 4.0227 3.7711 28.0692 20.2800 6.6034 0.7953 2.5806 1.4776 1.1791 1.1250 0.7614 0.8675 1.0252 1.0000 Write a SQL query to calculate total population, average percentage of white, black, and Asian population, average income per capita, and average median rent, by states. Sort by total population in descending order. The resulting table may look like: State California Texas New York Florida Pennsylvania Illinois Ohio total_population 37659181 25639373 19487053 19091156 12731381 12661727 11549590 Michigan 9886095 Georgia 9810417 North Carolina 9651380 1 avg_percent_white avg_percent_black avg_percent_asian avg_income avg_rent 27255.2759 932.9138 22813.8110 478.2008 27608.3710 691.6290 22904.4328 665.4478 25173.2985 551.2537 25223.0795 493.9659 23542.8068 498.6932 22830.2530 519.6867 20093.7736 480.2453 22042.2800 505.6600 56.5000 58.4724 82.3548 69.3433 89.5224 87.3636 91.0000 88.8554 63.5409 68.8000 3.1034 6.2323 5.7419 14.0896 4.2388 4.9432 4.0227 3.7711 28.0692 20.2800 6.6034 0.7953 2.5806 1.4776 1.1791 1.1250 0.7614 0.8675 1.0252 1.0000