1. Write a SQL statement to display the Major of the student with no duplications.
2. Write a SQL statement to display the First and Last name of students who live in the Zip code 88888.
3. Write a SQL statement to display the First and Last name of students who live in the Zip code 88888 and have the major of Biology.
4. Write a SQL statement to display the First and Last name of students who live in the Zip code 88888 or 88808. Do not use IN.
5. Write a SQL statement to display the First and Last name of students who have the major of Biology or Math. Use IN.
6. Write a SQL statement to display the First and Last name of students who have the Status greater than 1 and less than 10. Use BETWEEN.
7. Write a SQL statement to display the First and Last name of students who have the Last Name that starts with an S.
8. Write a SQL statement to display the First and Last name of students having an 'a' in the second position in their First Name.
9. Write a SQL expression to display the Status and a sum of SumOfStatus, grouped by Status. Name the count "SumOfStatus" and display the results in descending order of SumOfStatus.