Write the queries necessary to obtain the required information. Make sure all columns you return have descriptive column headings. Delete all sales reps that have no orders and were hired before Jan 1 1987.
Update your employee record with the following:
Age: 37 Rep_Office:39 Title: Senior VP Manager: NULL Quota: 100000
Increase customers credit limit by 25% for all customers that have 2 or more orders in which each order is more than 25,000.
Increase the credit limit of any customer who has any order that exceeds their credit limit. The new credit limit should be set to their maximum order amount plus $1,000. This must be done in 1 SQL statement.