LAB OVERVIEW

Lab 4 will introduce the various aspects of the SQL select statement and the methods of retrieving data from the database tables. This lab will also introduce the fundamentals of updating and deleting records. This lab may be completed using either DeVrys Omnymbus EDUPE-APP lab environment, or a local copy of the MySQL database running on your own computer using the ACME database tables. The lab will utilize a set of tables that are represented by the ERD (ACME.ERD.pdf) and are created and populated by the script file (Create_ACME_DB.sql). Follow the instructions in the file CreateACMETables.docx to create your database, tables, and data.

1. Write a query that displays the customers showing the company name and their credit limit. Sort the results by their credit limit in ascending order.
2. Write a query that displays all the column data from orders. Sort the results by customer Id in descending order.
3. Write a query that displays the order id, order date, and total amount. Sort the results by total amount in ascending order.
4. Write a query that displays each customer name with a heading of COMPANY_NAME, along with their phone number with a heading of PHONE_NUMBER.
5. Write a query that displays each customer name with a heading of COMPANY_NAME, along with their phone number with a heading of PHONE_NUMBER for customers that only have a credit limit of $50,000.

Offices SalesReps PK OfficelD RepID PK City Name Region Hire Date MgrlD Quota Target Sales ales FK Officel Customers Orders PK CustiD Products PK Ordid Company PK ProductlD Phone FK CustID Description OrderDate CreditLimit ProductPrice FK ProductID FK CustReplD Quantity_On Hand FK RepID QTY TotalAmt