Write a sql statement to display the first and last name


"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."

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: Write a sql statement to display the first and last name
Reference No:- TGS0146834

Expected delivery within 24 Hours