Access database

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

3 Simple steps to get your paper done

Step 1

Step 2

Step 3

Place Order Down to work Paper is Ready!

Takes just a few minutes!

Best writer takes the order

Access via your account

Professional nursing essay writers