Assignment \#10 Assignment \#10 (10 points) (10 points) The Premiere Products company is a distributor of appliances, house wares, and sporting goods. The company maintains sales representative, customer, order and inventory data. The Premiere Products 5. List the part number, part description, and on-hand value (units on hand " unit price) of each ERD model is shown below. The script to create the, schema, tables and load the data is located in D2L. vart in item class AP. Assien the name on hand value to the computation. After creating the schema in MySQL answer the questions below. 2. What is the part number, description, and price of the most expensive part in the database? 3. List the sum of the balances of all customers for each sales rep, but restrict the output to those sales reps for which the sum is more than $10,000. \begin{tabular}{ll} \hline rep_num & total_customer_bslance \\ \hline 20 & 27533.00 \\ 65 & 11303.00 \end{tabular} 4. Use the IN operator to list the part number and part description of each part in item class AP or is