Explore BrainMass
Share

Explore BrainMass

    SQL Query: Student Information

    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:35 am ad1c9bdddf
    https://brainmass.com/computer-science/sql/sql-query-student-information-510726

    Attachments

    Solution Preview

    1. Query1 Write a SQL statement to display Students' First and Last Name.
    SELECT Student.First_name, Student.Last_name
    FROM Student;

    2. Query2 Write a SQL statement to display the Major of students with no duplications. Do not display student names.
    SELECT DISTINCT MAJOR
    FROM Student;

    3. Query3 Write a SQL statement to display the First and Last Name of students who live in the Zip code 88888.

    SELECT Student.First_name, Student.Last_name
    FROM Student
    WHERE ZIP ='88888'

    4. Query4 Write a SQL statement to display the First and Last Name of ...

    Solution Summary

    The expert examines SQL Query for student information.

    $2.19