List all students and courses they are registered for

Assignment Help Computer Engineering

Reference no: EM132213891

Write SQL queries to produce the following results:

1) List all students and courses they are registered for. Include, in this order, CustomerNumber, CustomerName, Phone, CourseNumber, and AmountPaid.

2) List the total amount paid for each course starting after July 4, 2009. Include, in this order, CourseNumber, CourseName, and total amount paid for that course.

3) List the average amount paid for each customer. Include, in this order, CustomerName and average amount paid by that customer.

4) List all students registered in the Adv. Pastels starting on October 1, 2009. Include, in this order, CourseName, CourseDate, Fee, CustomerName, and Phone.

**COURSE**
CourseNumber	Course	CourseDate	Fee
1	Adv Pastels	10/1/2009	$500.00
2	Beg Oils	9/15/2009	$350.00
3	Int Pastels	3/15/2009	$350.00
4	Beg Oils	10/15/2009	$350.00
5	Adv Pastels	11/15/2009	$500.00

**CUSTOMER**
CustomerNumber	CustomerLastName	CustomerFirstName	Phone
1	Johnson	Ariel	206-567-1234
2	Green	Robin	425-678-8765
3	Jackson	Charles	360-789-3456
4	Pearson	Jeffery	206-567-2345
5	Sears	Miguel	360-789-4567
6	Kyle	Leah	425-678-7654
7	Myers	Lynda	360-789-5678

**ENROLLMENT**
CustomerNumber	CourseNumber	AmountPaid	FullFeePaid
1	1	$250.00	No
1	3	$350.00	Yes
2	2	$350.00	Yes
3	1	$500.00	Yes
4	1	$500.00	Yes
5	2	$350.00	Yes
6	5	$250.00	No
7	4	$0.00	No

Reference no: EM132213891

Questions Cloud

Write a single program to perform the miles to kilometers : Your program should ask the user for input and display the output following each conversion.

Create and initialize the array from the heap : Write a single program that call a function in C. Have the function create and initialize the array from the heap.

Why your position is stronger than another position : You want your supporting reason to explain why someone should support the position you are taking on the ethical question.

Write a sql statement that gives the customer counts : Write a SQL statement that returns the following information No row should appear more than once in the output Order your results by actor, then by film title.

List all students and courses they are registered for : List all students and courses they are registered for. Include, in this order, CustomerNumber, CustomerName, Phone, CourseNumber, and AmountPaid.

What is the reason you would do that : What is the reason you would do that? Try to explain as concretely as possible what your reason(s) would be for using the ring in the way you envision.

What is the best gate cost that you can find : a) What is the best gate cost that you can find? b) Convert the result into all-NOR logic.

Discuss the responsibilities of the group engagement partner : Discuss the Responsibilities of the Group Engagement Partner and the Group Engagement Team with audit reports? What are some responsibilities of the Group.

Define the labels source and dest and temp : Write a short program to copy 12 bytes of data from a SOURCE memory locations to DEST memory locations.

User Account

All Pages