C175 Cohort – Day 1 Exercises Premiere Products E-R Diagram
1. Select part_num, description, and price from the Part table.
2. Select all of the data in the Orders table (all attributes/all records).
3. Select customer_name from the Customer table where the credit_limit is greater than or equal to 10000.
4. Select the part_num and description where the class is not equal to AP.
5. Display the part_num, description, and total inventory value where the class is SG.
6. Display the part_num, description, and total inventory value for each part in the Part table where the total inventory value is greater than 7500.