Please answer the following question using QBE. Thank you

In the following exercises, you will use the data in the Premiere Product database. In each case, use QBE to obtain the desired results. Please submit a softcopy of your homework.

Please make a copy of the database before you start your homework. We need the database in its original state for later discussion.

1. list the number and name of all customers that are represented by sales rep 65
2. for each order, list the order number, order date, the number of the customer that placed the order, and the name of the customer that placed the order
3. find the total of the balances for all customers represented by sales rep 65
4. list all columns and all records in the Part table. Sort the results by part number within item class
5. create a new table (Please just write a query, do not execute the query) named Appliance to contain the columns PartNum, Description, OnHand, Warehouse, and Price for all rows in which the item class is AP.
6. In the Part table, change the description of part KL62 to Electronic Dryer (Please just write a query, do not execute the query)

Rep City RepNum LastName First Name Street City State Zip Commissid 20 Kaiser Valerie 624 Randall Grove FL 33321 $20,542.5 35 Hull Richard 532 Jackson Sheldon FL 33553 $39,216.0 65 Perez Juan 1626 Taylor Fillmore FL 33336 $23,487.0 Customer Customer Num CustomerName Street State Zip Balance Cr 148 Al's Appliance 2837 Greenway Fillmore FL 33336 $6,550.00 S and Sport 282 Brookings 3827 Devon Grove FL 33321 S431.50 $1 Direct 356 Ferguson's 382 Wildwood Northfield FL 33146 $5,785.00 S 408 The Everything 1828 Raven Crystal FL 33503 $5,285.25 s Shop 462 Bargains Galore 3829 Central Grove FL 33321 $3,412.00 $1 524 Kline's 838 Ridgeland Fillmore FL 33336 $12,762.00 $1 608 Johnson's 372 Oxford Sheldon FL 33553 $2,106.00 S1 Department Store S S 687 Lee's Sport 282 Evergreen Altonville FL 32543 $2,851.00 and Appliance 725 Deerfield's 282 Columbia Sheldon FL 33553 $248.00 Four Seasons 842 All Season 28 Lakeview Grove FL 33321 $8,221.00 Orders Orderline Order Num Order Date Customer Num Order Num PartNum NumOrdered QuotedPrice 21608 10/20/2013 148 21608 AT94 11 $21.95 21610 10/20/2013 356 21610 DR93 1 $495.00 21613 10/21/2013 408 21610 DW11 1 $399.99 21614 10/21/2013 282 21613 KL62 4 $329.95 21617 10/23/2013 608 21614 KTO3 2. $595.00 21619 10/23/2013 148 21617 BV06 2 $794.95 21623 10/23/2013 608 21617 CD52 4 $150.00 21619 DR93 1 $495.00 21623 KV29 2. $1,290.00 OnHand Class Warehouse 50 HW 3 45 SG 2 32 AP 1 21 HW 3 Part PartNum Description AT94 Iron BV06 Home Gym CD52 Microwave Oven DL71 Cordless Drill DR93 Gas Range DW11 Washer FD21 Stand Mixer KL62 Dryer KT03 Dishwasher KV29 Treadmill 8 AP Price $24.95 $794.95 $165.00 $129.95 $495.00 $399.99 $159.95 $349.95 $595.00 $1,390.00 12 2 3 3 1 AP 22 HW 12 AP 8 AP 3 9 SG 2 FIGURE 2-1 Sample data for Premiere Products