Instructions: Use the Student data and the movie data $($when needed$)$ for the following queries. Copy and Paste your queries $($the sql$),$ a sample of your data, and the number of rows into a Word document. Then, upload it to Blackboard. To complete your work, please include: $1.$ The query itself $2.$ The number of rows $3.$ And a small sample of data Remember: GROUP BY is a clause in a select statement that is designed to be used in conjunction with aggregate functions $($such as count or average$).$ It will return one row for EACH value of the column$($s$)$ that is$($are$)$ grouped. And the Having clause is used as a final filter on a select statement. It filters the result set by a condition AFTER the grouping function has been applied. Please also note $$ that some of these are leading us to joins and subqueries. $1.$ Display the states and how many students are from each state for female students only $($ordered in alphabetical order by state$).2.$ Display the number of female students and the number of male students from Massachusetts. $3.$ Display the number of individual students taking each CRN and order the records from the highest count down. Use an alias for the count column. $4.$ Display the states and how many male students are from each state where the count is greater than $11.5.$ Display the names of the states and how many students are from each state for students that have a GPA $>$ the avg students GPA. $6.$ Display the names of the states that have at least $5$ students that have a GPA $>$ the avg students GPA. $7.$ Display the names of the students that are from NY and taking $4$ courses. $8.$ Display the names of the actors and how many movies they are in for those that have starred in more than $2$ movies. $9.$ Display the movie titles and how many actors are in the movie. $10.$ Display the movie titles that are rated PG or PG$13$ and have been directed by John Hughes