Create a Database and modify your script to reference your Database

Create a MySQL database:

Running script file in MySQL, create SQL SELECT Queries

Query1 Write a SQL statement to display Student's First and Last Name.

Query2 Write a SQL statement to display the Major of students with no duplications. Do not display student names.

Query3 Write a SQL statement to display the First and Last Name of students who live in the Zip code 82622

Query4 Write a SQL statement to display the First and Last Name of students who live in the Zip code 97912 and have the major of CS.

Query5 Write a SQL statement to display the First and Last Name of students who live in the Zip code 82622 or 37311. Do not use IN.

Query6 Write a SQL statement to display the First and Last Name of students who have the major of Business or Math. Use IN.

Query7 Write a SQL statement to display the First and Last Name of students who have the Class greater than 1 and less than 10. Use the SQL command BETWEEN.

Query8 Write a SQL statement to display the First and Last Name of students who have a last name that starts with an S.

Query9 Write a SQL statement to display the First and Last Name of students having an a in the second position of their first names.

Query10 Write a SQL expression to display each Status and the number of occurrences of each status using the Count(*) function; display the result of the Count(*) function as CountStatus. Group by Status and display the results in descending order of CountStatus.

Attachment:- assignment.rar