Class: Business Data Management - SQL WORKBENCH

PLEASE HELP ANSWER ALL CORRECTLY, I WILL GIVE THUMBS UP THANKS!

Q1. Use TopBabyNamesbyState.csv 1 and write queries to extract the following information: 1) A list of all columns in this dataset? 2) How many rows are there in this dataset? 3) A list of unique names in this dataset ordered alphabetically from A to Z ? 4) How many unique names are there in this dataset? 5) Which name in which state and in which year had the highest number of occurrences. 6) What is the average occurrence of "Jessica" as a top name in the state of CA? 7) How many years was "Mary" the top name in California? Name the computed column as "Mary_topinCA". 8) The three most popular female names in WA state since 2000. Popularity is based on the total number of occurrences. Report the names along with the total number of occurrences. 9) Make a list of names that have an average occurrence greater than 1000. Order the result table by name in an ascending alphabetical order. Q2. Use Employee.sql and Office.sql and write queries to extract the following information: 1) Get IDs of employees whose first name starts with "pa", followed by three characters and then ends with " a ". Show the first name along with the employee ID. 2) (Multiple Tables) How many employees at non-regional offices were hired after 2000 ? 3) (Multiple Tables) Get the Employee ID of the newest Account Rep who is working in a location with audit code=100. 4) Get the average salaries for each of the following three groups: poor-performing account reps, poor-performing managers, and poor-performing trainees. Show the title and performance along with the average salaries. 5) Retrieve all information about employees whose hired date is 31 and whose last name consists of exactly five characters. 6) (Multiple Tables) Make a list of all employees who have a salary more than the average salary of all employees. 7) (Multiple Tables) How many female employees have a salary higher than the average salary of all employees? - Your queries should extract the answers directly. If you need additional steps (e.g., hand counting the number of rows) to get the answer after running a query, the query is not considered as the right query for the