Details of this Paper

Access database

Description

solution


Question

Name;Task;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.;Student_ID;Last_Name;First_Name;Address;Zip;Major;Class;1;Smith;James;555 Ohio Road;88888;Business;5;2;Doe;Jane;32 3rd Ave;88888;Biology;10;3;Miller;Mark;511 Easy streer;88808;Math;5;4;Smith;Ty;54 Main Street;88808;Math;3

 

Paper#71461 | Written in 18-Jul-2015

Price : $27
SiteLock