1. Write a SQL statement to display Students' First and Last Name.

1. Write a SQL statement to display Students' First and Last Name.

2. Write a SQL statement to display the Major of students with no duplications. Donot display student names.

3. Write a SQL statement to display the First and Last Name of students who live inthe Zip code 88888.

4. Write a SQL statement to display the First and Last Name of students who live inthe Zip code 88888 and have the major of Biology.

5. Write a SQL statement to display the First and Last Name of students who live inthe 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 themajor of Biology or Math. Use the SQL command IN.

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