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 |