MySQL database problem, please help; I will definitelt give a thumb up Thank you so much!

I have these tables:

some contents in the table:

committess:

counties:

senators:

states:

Create a text file named xx.sql with your SQL statement answers for the following as a working .sql file. Test your script with the command:

source xx.sql

1. List all state names and their 2-letter codes. 2. Write a query to report the following information for all counties whose names start with "Prince". (Hint: Use "like"). Expected Output columns: a. name b. statecode c. populate_1950 d. population_2010 3. Write a single query to list only the population in year 2010 for the state represented by Sen. Richard Lugar. Output column: populate_2010 4. Write a single query to report only the total number of the counties in 'Maryland'. The query should not hard-code the state code for Maryland (join the two tables in the WHERE clause) 5. Write a single query to find the name of the state that was admitted last into the union. Hint: Use nested subquery. 6. Find all democratic (i.e., with affiliation = 'D') senators that are not chairman of any committee or subcommittee. Expected Output columns: name Order by name.

es; I Tables_in Hw3 I committees | counties | senators l states