Write a sql statement to display the major of students with


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

Query2 Write a SQL statement to display the Major of students with no duplications. Do not display student names.

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

Query4 Write a SQL statement to display the First and Last Name of students who live in the Zip code 88888 and have the

majorof Biology.

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

Query6 Write a SQL statement to display the First and Last Name of students who have the major of Biology or Math. Use the

SQL command IN.

Query7 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 the SQL command BETWEEN.

Query8 Write a SQL statement to display the First and Last Name of students who have a last name that starts with an S.

Query9 Write a SQL statement to display the First and Last Name of students having an a in the second position in their first

names.

Query10 Write a SQL expression to display the Status and a sum of the Status of each Status value as SumOfStatus. Group by

Status and display the results in descending order of SumOfStatus.

Attachment:- Lab_1_SQL.rar

Solution Preview :

Prepared by a verified Expert
PL-SQL Programming: Write a sql statement to display the major of students with
Reference No:- TGS01241131

Now Priced at $50 (50% Discount)

Recommended (99%)

Rated (4.3/5)