Access database

of students with no duplications. Do not display student names.

code

. Do not use IN.

. Use the SQL command IN.

Name

Task

Query1

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

Query2

Write a SQL statement to display the

Major

Query3

Write a SQL statement to display the First and Last Name of students who live in the

Zip

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 major of

Biology

Query5

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

88808

Query6

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

Math

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.

ZipMajor

88888

88888Biology10

88808Math5

4SmithTy

88808Math3