Course Project Phase 1 (Course: Database Systems)
Query # 1Write a SQL statement to produce output as follows: Student’s First and Last Name.
Query # 2Write a SQL statement to produce output as follows: the Major of the STUDENT with no duplications. Do not display student names.
Query # 3Write a SQL statement to produce output as follows: First and Last Name of students who live in the Zip code 32828.
Query # 4Write a SQL statement to produce output as follows: First and Last Name of students who live in the Zip code 97912 and have the major of CS.
Query # 5Write a SQL statement to produce output as follows: First and Last Name of students who live in the Zip code 32826 or 33186. Do not use IN.
Query # 6Write a SQL statement to produce output as follows: the First and Last Name of students who have the major of Business or Math. Use IN.
Query # 7Write a SQL statement to produce output as follows: the First and Last Name of students who have the Class greater than 1 and less than 5. Use BETWEEN.
Query # 8Write a SQL statement to produce output as follows: First and Last Name of students who have the Last name that starts with an M.
Query # 9Write a SQL statement to produce output as follows: First and Last name of students having an o in the second position in their First Name.
Query # 10Write a SQL expression to produce output as follows: display the Status for, and the number of occurrences that apply to each status. You must