Explore BrainMass
Share

Explore BrainMass

    SQL Query Statements

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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 October 10, 2019, 5:53 am ad1c9bdddf
    https://brainmass.com/computer-science/sql/sql-query-statements-521043

    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