Explore BrainMass
Share

SQL Query Statements

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.

© BrainMass Inc. brainmass.com June 25, 2018, 1:53 pm ad1c9bdddf

Attachments

Solution Preview

Dear student,

Please find attached the solution.

Thanks, ...

Solution Summary

This solution contains the queries written in a very easy to understand manner with proper formatting (required capitalization of words etc.) . The attached word document contains the tabulated queries with one column containing the problem and other column contains the query.

$2.19