Purchase Solution

SQL Statement for Grades

Not what you're looking for?

Ask Custom Question

See the attached file.
8. Consider the following tables:

Customers
CustomerID LastName FirstName State
1 Cohen Mike CO
2 Highley Michelle MI
3 Cohen Margot MI

Orders
OrderID CustomerID Ordered_Item Date_Ordered
1 3 DVD Movie 1/1/2009
2 1 Computer Book 3/1/2009
3 2 Music CD 2/1/2009

Write an SQL statement that will return the following result:

Name Location Item Date
Margot Cohen OH DVD Movie 1/1/2009
Michelle Cohen GA Music CD 2/1/2009
Mike Cohen CO Computer Book 3/1/2009

9. Using the two tables from #8, write an SQL statement that uses a SUB QUERY and the IN keyword to return the First Name of the customers who live in the state of MI.

10. Tell why the following SQL statement is incorrect. Rewrite the SQL statement to make it correct. (Hint: The fields of the table are StudentName, Assignment, Grade. A student's name can be in the table more than once since they could have several assignments.)

SELECT StudentName, AVG(Grade)
FROM GradeBookTable.

Attachments
Purchase this Solution
Solution Summary

The solution examines SQL statements for students grades.

Solution Preview

See the attached file.

8. Consider the following tables:

Customers
CustomerID LastName FirstName State
1 Cohen Mike CO
2 Highley Michelle MI
3 Cohen Margot MI

Orders
OrderID CustomerID Ordered_Item Date_Ordered
1 3 DVD Movie 1/1/2009
2 1 Computer Book 3/1/2009
3 2 Music CD 2/1/2009

Write an SQL statement that will return the following result:

Name Location Item Date
Margot Cohen OH DVD Movie 1/1/2009
Michelle Cohen GA Music ...

Purchase this Solution
Free BrainMass Quizzes
Excel Introductory Quiz

This quiz tests your knowledge of basics of MS-Excel.

C# variables and classes

This quiz contains questions about C# classes and variables.

Java loops

This quiz checks your knowledge of for and while loops in Java. For and while loops are essential building blocks for all Java programs. Having a solid understanding of these constructs is critical for success in programming Java.

Basic Networking Questions

This quiz consists of some basic networking questions.

Basic UNIX commands

Use this quiz to check your knowledge of a few common UNIX commands. The quiz covers some of the most essential UNIX commands and their basic usage. If you can pass this quiz then you are clearly on your way to becoming an effective UNIX command line user.

View More Free Quizzes
Related BrainMass Solutions

  • SQL Query: Student Information

    SELECT Student.Status, sum( Student.Status) as SumOfStatus FROM Student GROUP BY Student.Status ORDER BY sum( Student.Status) DESC; The expert examines SQL Query for student information.

  • SQL Statement

    Write 1 SQL query that will prove that no records exist for ConsumerID 45678 or the Consumer is from California or Texas. g. Save your SQL query as SQLQuery1D3 and execute the statement. h. Take a screen shot of your query results.

  • SQL Query Statements

    521043 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.

  • SQL Commands

    Write a SQL statement to show SKU and Description for all products having a description starting with 'Half-Dome'. 3. Write a SQL expression to display the Warehouse and a count of QuantityOnHand, grouped by Warehouse.

  • Oracle9i

    Change the password of the CLASSMATE user back to CLASSPASS using the SQL*Plus worksheet. Save the SQL statement file. SQL> ALTER USER CLASSMATE IDENTIFIED BY CLASSPASS Oracle9i is highlighted for password classmates.

  • MS SQL SERVER 2003

    Problem 2 In addition create your own SQL query from the database · GROUP statement · UNION statement · JOIN statement · INSERT statement · DELETE/DROP statement select Store.Store_Name, Store.Store_Phone_Number, Customer.Phone_Number from

  • SQL Operator Definitions

    For example, the SQL statement will add a new row and add data in the C_Id, Name, and city columns INSERT INTO Company (C_Id, Name, City) VALUES (4, 'DONALD', 'Washington D.C.'

  • Creating a databse using Microsoft SQL Server

    247889 Creating a databse using Microsoft SQL Server Using Microsoft SQL Server CREATE DATABASE, CREATE TABLE, and SQL INSERT statements. Use the CREATE DATABASE statement to create a SQL Server database for Kudler Fine Foods.

  • The Appearance of the Relation Result

    I have never seen the PROJECT statement in SQL, nor can I find it in any of the SQL references online (see end of posting).

View More Related Solutions