SQL or MS Access steps (only highlighted questions)

ises I use the data in the BITS database shown in Figure 1-5 in Che cises, use a copy of the original BITS database so you will still 4.) In each step, use SQL to obtain the desired results. You c omputer, or you can simply write the SQL command to comple Arteln ahawlah namanhia dala 1 lat placed the order, and name 7. List the number and name of all clients represented by Sarah Allen. 8. How many clients have a credit limit of $10,000? 9. Find the total of the balances for all clients represented by consultant 35. 10. List the name and remaining credit (CreditLimit-Balance) for each client 11. List all columns and all rows in the Client table. Sort the results by name. 12. List all columns and all rows in the Tasks table. Sort the results by price within calegory. 13. For each consultant, list the consultant last name, the average balance of the consultant's clients, and the number of clients assigned to the consultant. Group the records by consultant name, and order the records by consultant name. 14. Create a new table named Sep121 to contain the columns OrderNum, Taskid, Description, ScheduledDate, QuotedPrice for all rows on which the Scheduled Dale is 9/21/2018. 15. In the Sept21 tablo, change the description of TaskID P154 to "Misc. Printing." 16. In the Sep121 table, add a new order. The order number is 69123. The Taskid is OT99. The scheduled date le 9/21/2018. The quoted price is $99.99. The description is Other work. 17. There are two ways to create the query in Exorciso 12. Writo the SQL command that you used and then 129 Anvart van Text Formatting - - Client Consultant In Orderline un Tasks Client Num . ClientName - 143 Hershey, Jarrod 4 175 Goduto, Sean 299 Two Crafty Cousins Prichard's Pizza & Pasta Salazar, Jason Fisherman's Spot Shop Seymour, Lindsey Bonnie's Beautiful Boutique Yates, Nick Howler, Laura Harpersburg Bank MarketPoint Sales Find Workord.. Street 135 E. Mill Street 12 Saratoga Parkway 9787 NCR 350 West 501 Air Parkway 56473 Cherry Tree Dr. 49 Elwood Ave. 4091 Brentwood in 9565 Ridge Rd. 231 Day Rd. 1368 E. 1000 S. 65 Forrest Blvd. 826 Host St. City State - Easton FL Tricity Sunland FL Lizton Easton Harpersburg FL Amo Tri City Sunland Lizton Harpersburg FL Easton ZipCode 33998 32889 39876 34344 33998 31234 34466 32889 39876 34344 31234 33998 Balance - Creditimit . Consitur $1,904,55 $2,500.00 19 $2,814.55 $5,000.00 19 $8,354.00 $10,000.00 22 $7,335.55 $10,000.00 35 $900.75 $2,500.00 35 $4.111.40 $7,500.00 19 $557.70 $5,000.00 22 $4,053.80 $7,500.00 22 $2,523.80 $2,500.00 35 $3,658.05 $5,000.00 22 $5,824.55 $10,000.00 19 $3,089.00 $5,000.00 19 Find Text Formatting State Hours Sort & Filter Records Client Consultant Orderline Tasks Workord... ConsitNur - LastName - FirstName - Street City Turner Christopher 554 Brown Dr. Tri City Jordan Patrick 2287 Port Rd. Easton Allen Sarah 82 Elliott St. Lizton Shields Tom 373 Lincoln Ln. Sunland ZipCode 32889 33998 34344 39876 - Rate - 40 $22.50 40 $22.50 35 $20.00 10 $15.00 2 Client Consultant OrderNum - Taskid 67101 SI77 67313 LA81 67424 M049 67424 UP38 67838 LA81 67949 P154 67949 VR39 67949 WA33 68252 D185 68868 SA44 68979 AC65 68979 DA11 Orderline @ Tasks 2 Workord... - ScheduledDate - QuotedPrice 9/10/2018 $144.00 9/12/2018 $104.00 9/14/2018 $65.00 9/14/2018 $185.00 9/20/2018 $104.00 9/21/2018 $50.00 9/21/2018 $88.00 9/21/2018 $126.00 9/24/2018 $50.00 9/24/2018 $200.00 9/27/2018 $77.00 9/27/2018 $970.00 Find Sort & Filter 33 Client Consultant Orderline BE: Tasly Taskid - Description AC65 Accessories # DA11 Data recovery major # D185 Data recovery minor # HA63 Hardware major # H131 Hardware minor + LA81 Local area networking (LAN) + M049 Mobility # OT99 Other work # P154 Printing issues #SA44 Software major # S177 Software minor + S191 Security install/repair + UP38 Upgrades + VR39 Virus removal + WA33 Wide area networking (WAN) Records WorkOrd... Category - ACC DRM DRM HAM HAM LAN MOB OTH PRI SOM SOM Price $80.00 $175.00 $50.00 $225.00 $165.00 $104.00 $65.00 $99.99 $50.00 $200.00 $144.00 $126.00 $185.00 $90.00 $130.00 denn SIR UPG VIR WAN LAILA NAICO 2 WorkOrders - Client 2 Consultant 2 Orderline Tasks OrderNum - OrderDate - ClientNum # 67101 9/6/2018 733 # 67313 9/7/2018 458 + 67424 9/10/2018 322 # 67838 9/10/2018 867 + 67949 9/10/2018 322 + 68252 9/12/2018 363 + 68868 9/14/2018 867 # 68979 9/17/2018 826