To complete the assignment, follow the instructions below.
Use the auto repair shop database found within this zip file to create the 15 queries described below. Save each query with an identifying name. E.G. Query 1 for item #1.
Display all fields for all the records in the Jobs table.
Display the Job ID, Customer ID, and Job Status for all records in the Jobs table.
Display the Job ID, Customer ID, Job Status, and Quote for all jobs with a Job Status of C.
Display the Job ID, Customer ID, Job Status, and Completion Date for all jobs with a Completion Date after June 1, 2001.
Display the Job ID, Customer ID, Job Status, and Quote for all jobs with a Job Status of I and a Quote of more than $1000.
Display the Job ID, Customer ID, Job Status, and Completion Date for all jobs with a Job ID that begins with P.
Display the Job ID, Customer ID, Completion Date, and Quote for all jobs with a Completion Date before March 30, 2001 or a Quote of less than $500.
Display the Job ID, Customer ID, Job Description, and Quote for all jobs with a Quote greater than $500 and less than $1,000. (Hint: Enter a criteria of “>500 And <1000” for Quote.)
Display the Job ID, Customer ID, Job Status, and Completion Date of all records in the Jobs table sorted in ascending sequence by Customer ID.
Using all the fields, display and print all the records in the Jobs table sorted in ascending sequence by Job ID within Customer ID.
Add the Customer table. Using the fields Job ID, Customer ID, Job Status, Customer Name, and Telephone, display all records.
Restrict the records retrieved in task 11 to only jobs with a Job Status of I. Display the results.
From the Jobs table, display the highest Quote with a Job Status of I.
From the Jobs table, display the average Quote by Customer ID.
If each customer is required to make a 10% deposit for each job, display the Job ID, Customer ID, and deposit amount for every record in the Jobs table.
