Using the Student table in the database provided in the Doc Share (Lab 5 SQL.accdb), perform the following tasks:
1. Write a SQL statement to display First and Last Name.
2. Write a SQL statement to display the Major of the student with no duplications.
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 and have the major of Biology.
5. 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.
6. Write a SQL statement to display the First and Last name of students who have the major of Biology or Math. Use IN.
7. 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.
8. Write a SQL statement to display the First and Last name of students who have the Last Name that starts with an S.
9. Write a SQL statement to display the First and Last name of students having an 'a' in the second position in their First Name.
10. 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.