Build a Pivot that shows total State employment across the top and Occupation down the side for the four states

Learning Goal: I’m working on a mysql multi-part question and need an explanation and answer to help me learn.Build a new table of unique State to State Code
Join that new table to Current via Series and filter the data to the following States: California, New York, Illinois, Texas, and Florida
Filter #2 to just Total Employment in All Occupations
Build a Pivot that shows total State employment across the top and Occupation down the side for the four states
Build a dynamic SQL Pivot that shows total State employment across the top and Occupation down the side for ALL states.
Build a dynamic SQL Pivot that shows the 10th, 25th, Median, 75th, and 90th Percentiles for Hourly Wages of Total Occupation across the top, with Occupation on the right. Limit this to just US Level data. Your column headers for the percentiles should be the titles for the data types, not the coded values
Turn in – Script that does 1 through 3 aboveTurn in – Top 10 rows from #2 after you order the data by OccupationTurn in – Top 10 rows from #3 after you order the data by Occupation
Requirements: 1 page