Create a SQL query to satisfy each of the tasks below.
Save each SQL query using the name associated with the task in the table below

You must create an sql code for each tasks and ensure when executed in ms access will return results of each of qjuestion asl. you should have 10 queries

Transcribed Image Text:

Task ueryl Write a SQL statement to display Students' First and Last Name rite a SQL statement to display the Major of students with no uery2 eyuplcaions. Do not display student names av student names rite a SQL statement to display the First and Last Name of udents who live in the Zip code 88888 uery3 rite a SQL statement to display the First and Last Name of uery4 students who live in the Zip code 88888 and have the major of ology rite a SQL statement to display the First and Last Name of udents who live in the Zip code 88888 or 88808. Do not use IN uery rite a SQL statement to display the First and Last Name of uery6 students who have the major of Biology or Math. Use the SQL command IN rite a SQL statement to display the First and Last Name of uery7 students who have the Status greater than 1 and less than 10. Use he SQL command BETWEEN rite a SQL statement to display the First and Last Name of uery v8 udents who have a last name that starts with an $S rite a SQL statement to display the First and Last Name of uery9 dents having an a in the second position in their first names rite a SQL expression to display the Status and a sum of the isplay the results in descending order of SumOfStatus uery10 Status of each Status value as SumOfStatus. Group by Status and Student Class Last Name Status First Name Student ID Zip Address Major Smith James Doe 10 ane288888 32 3rd Ave Biology Miller 5 Mak3 Smith 3 Ty 88888555 Ohio Road Business 88808 511 Easy streer Math 888 0854 Main Street Math