BCMP2007 Class 7Practice Write the SQL code below the statement V2 PDF

Preview

Summary

BCMP2007 Class 7Practice Write the SQL code below the statement V2...

Description

BCMP 2007 Class 7 SQL Practice V2 – NOT FOR SUBMISSION Write the SQL code below the statement/question. Based on the Recruiters Database. Example question and solution: Question: Prepare a list of Client locations (by postal code only). Answer: SELECT CLIENT.ClientName, CLIENT.PostalCode FROM CLIENT;

1. Show a list of Recruiters’ addresses. {type your answer in here in SQL statement form. Answers must be 100% correct to score the mark.} 2. Prepare a list of Recruiters and the Clients they service. {answer to question 2 goes here, and so on…} 3. Prepare a list of Clients, the amount they have already paid, and how much they still owe.

4. Prepare a list of Clients, the amount they have already paid, and how much they still owe, but, only include those who have paid more than $20,000, and currently owe nothing.

5. Prepare a list of Clients, the amount they have already paid, and how much they still owe, but, only include those who have paid more than $20,000, or currently owe nothing.

6. Generate a list of Recruiters who live in the city of Denton. (Don’t show the city name in the results).

7. Show the average commission amount that all Recruiters have earned.

8. Prepare a list of Clients, the amount they have already paid, and how much they still owe. Calculate the Total Amount (as a new field: TotalAmount). Only include those who have paid less than $20,000.

*this is not graded practice. There is nothing to hand in....