Share
Explore BrainMass

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.

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