please help me with this assignment:

ch 2 BITS Corporation Exercises: QBE

thank you!

Consultant Contam LastName First Name Street State Zip Code Hours Rete 19 Turner Christopher 554 Brown Dr Tri City F. 3269 40 $22.50 Jordan Patrick 2287 Port Rd. Faston FL 33098 40 $22:50 35 Allen Sarah 82 S Linton PL 34144 35 $20.00 51 Shields Tom 373 Lincoln LA Sunland FI 39876 10 $15.00 Client Client Num ClientName Street City State ZipCode Balance CreditLimit Consum Hershey, Jarrod 135 E Mal Street Easton FL 3.1998 $1,90435 $2.500.00 19 175 Goduts, Sean 12 Saratoga Parkway Tri City FL. 3289 $2.814.55 $5.000.00 19 299 Two Crafty 9787 NCR 350 Sunland HL. 1976 $3,154.00 $10,000.00 22 Cousins West Pricharda & 501 Air Parkway Linton FL 57,335 35 310,000.00 35 Pasta 363 Salamar, Jason 56473 Cherry Tree Dr Faston FL 3.3998 $900.75 $2,500.00 35 405 Fisherman's Spot 49 wood Ave. Harpersburg Fl. 31234 $4,113.40 $7,500.00 19 Shop Seymour, 4091 Brentwood LA Amo HL. 34466 $557.70 $5,000.00 22 Lindsey Bonnie Beautiful 9565 Ridge Rd. Tri City FL 32889 $4,053 0 $7,500.00 22 Boutique 677 Yates, Nick 131 Day B4 Sunland FL. 39876 $2,523.80 $2,500.00 35 733 Howler, Laura 1368 E 1000 Lanton FL. 34344 33,658.05 $5,000.00 X26 Harpenburg Bank 65 Forest Blvd Harpersburg H. 31234 56,824.55 $10,000.00 19 MarketPoint Sales 26 Host St. FL. 33998 $3,089.00 35,000.00 19 WorkOrders OrderLine OrderNum Order Date Client Num Order Num TaskID ScheduledDate QuotedPrice 67101 96/2015 733 67101 5177 9/10/2018 $144.00 67313 97/2018 458 67313 LASI 9/12/2018 $104.00 67424 9/10/2015 322 67424 M049 9/14/2015 $65.00 67635 9/10/2015 867 67424 UP 9/14/2018 $185.00 67949 9/10/2018 322 67836 LAND 9/20/2018 $104.00 06252 9/12/2016 363 679.49 P154 9/21/2018 $50.00 68368 9/14/2015 867 67949 VR39 9/21/2018 $88.00 68979 9/17/2018 67949 WA33 9/21/2018 $120.00 0252 DINS 9/24/2018 350.00 SA44 9/24/2018 $200.00 68979 AC05 9/27/2018 $77.00 68979 DA11 9/27/2018 3970.00 Tasks Taski Description Category Price ACAS Accessories ACC $80.00 DATI Data recovery major DRM $175.00 DINS Data recovery minor DRM $50.00 HA63 Hardware major HAM $225.00 Hai Hardware minor HAM $165.70 LAX Local area networking (LAN) LAN 510400 MO49 Mobility MOR $65.00 OTVO Other work OTH $99.99 E'S Printing PRI $50.00 SA44 Solema SOM $200.00 S177 Solare minor SOM S101 Security install repair SER $126.00 UPM Upgrade UPCO $133.00 VR Virus removal VIR 190.00 WAS Wide area betworking (WAN WAN $110.00 WC19 Web connectivity WEC $75.00 826 poration Exercises: QBE ment: Ch 2 BITS Corporation Exercises: QBE Assignment Score: 0.00% Save Submit Assignment for Grading praed09h_cho2_QBE.01 Question 1 of 1 . BITS Corporation Exercises: QBE In the following exercises, you will use the data in the Brts Corporation database shown in Figure 2-1. (If you use a computer to complete these exercises, use a copy of the BITS Corporation database so you will still have the original data when you complete Chapter 3.) In each step, use QBE to obtain the desired results. You can use the query feature in a DBMS to complete the exercises using a computer, or you can simply write a description of how you would complete the task. Check with your instructor if you are uncertain about which approach to take Save the file on your computer with your last name in the file name. (Example: case_1-1_Jones.doc) Click the Choose File button to find and select your saved document. Consultant Lethane StoCodes Rate Cupher TW Tanto PL SI Client re T De 122.50 23 PL 40 40 35 10 Alle 20.00 BISOO CE 15. Ma Code Blanes Crem 0.00 19 3.14.55 000.00 10 14.00 0.00 22 FI TH City Sunda Thy WINT NORS 25 ch 501Aw Pub 57,31535 510,000.00 473 Cherry Tree by Am 67.500.00 19 homme She Am H. 456 $57.70 57.000 THC 2000 3456 13,00 DO . 43.00 . 2 Day H 1000S HL Har PL H Order Line 10 WorkOrders Corporation Exercises: QBE Q Search thie FOURE 241 Sample data for BITS 1. List the number and name of all clients. 2. List the complete Tasks table. 3. List the number and name of all clients represented by consultant 19. 4. Last the number and name of all clients that are represented by consultant 19 and that have a credit limit of $10,000 5. List the number and name of all clients that are represented by consultant 19 or that have a credit limit of $10,000. 6. For each order, list the order number, order date, number of the client that placed the order, and name of the client that placed the order. 7. List the number and name of all clients represented by Patrick Jordan. 8. How many clients have a credit limit of $5,000? 9. Find the total of the balances for all clients represented by consultant 22. 10. List the ClientNum, CreditLimit, and Balance, and list the available credit (Creditlamit - Balance) for each client represented by consultant 19. 11. List all columns and all records in the Consultant table. Sort the results by last name. 12. List all columns and all records in the Tasks table. Sort the results by price within category. 13. List theategory and price for all orders. Group the results by category. 14. Create new table named ScheduledClients to contain client's name, the scheduled date of service, task ID, description of the service, and the quoted price 15. In the scheduledClients table, change the description of item VR39 to "Virus detection and removal." Adjust the column widths as necessary, 16. In the scheduledClients table, delete every row on which the price is greater than $500. 17. There are two ways to create the query in Exercise 11. What are they? Which one did you use? 18. An employee of BITS Corporation created the query shown in Figure 2-48. She wants to list the client number and the task 1Ds associated with each order Will the query results be correct? If so, list other fields that would be useful. If not, how should she modify the query to achieve this result? Olun key