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. List 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 (CreditLimit - 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 the category and price for all orders. Group the results by category.
14. Create a new table named ScheduledClients to contain clients 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 IDs 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?

Consultant ConsitNum LastName FirstName Street City |Tri City Easton State ZipCode Hours Rate FL Christopher Patrick 554 Brown Dr. 2287 Port Rd. Turner Jordan 19 32889 40 $22.50 $22.50 22 FL. 33998 40 35 Allen Shields Sarah Tom 82 Elliott St. Lizton FL 34344 35 $20.00 373 Lincoln Ln. Sunland FL $15.00 51 39876 10 Client ClientNum ClientName Street City Easton State ZipCode Balance Creditlimit ConsitNum Hershey, Jarrod Goduto, Sean 135 E. Mill Street FL. $2,500.00 143 33998 $1,904.55 19 12 Saratoga Parkway Tri City FL 175 32889 $2,814.55 $5,000.00 19 Two Crafty Cousins 9787 NCR 350 Sunland FL $8,354.00 $10,000.00 299 39876 22 West 501 Air Parkway Prichard's Pizza & FL 322 Lizton 34344 $7,335.55 $10,000.00 35 Pasta Salazar, Jason 56473 Cherry Tree Dr Easton $900.75 363 FL $2,500.00 33998 35 Fisherman's Spot Shop 49 Elwood Ave. Harpersburg FL $4,113.40 $7,500.00 405 31234 19 Seymour, Lindsey 4091 Brentwood Ln Amo FL 449 34466 $557.70 $5,000.00 22 Bonnie's Beautiful Boutique Yates, Nick Howler, Laura Harpersburg Bank 9565 Ridge Rd. Tri City FL. $4,053.80 458 32889 $7,500.00 22 231 Day Rd. Sunland FL $2,523.80 $2,500.00 677 39876 35 1368 E. 1000 S. Lizton FL. 34344 $3,658.05 $5,000.00 733 22 65 Forrest Blvd. Harpersburg FL 826 31234 $6,824.55 $10,000.00 19 867 MarketPoint Sales 826 Host St. Easton FL $3,089.00 s5,000.00 33998 19 WorkOrders OrderLine OrderNum TaskID ScheduledDate QuotedPrice OrderNum OrderDate ClientNum 9/6/2018 S177 9/10/2018 67101 733 67101 $144.00 67313 LASI 67313 9/7/2018 458 9/12/2018 $104.00 9/10/2018 MO49 $65.00 67424 322 67424 9/14/2018 67838 UP38 9/10/2018 867 67424 9/14/2018 $185.00 9/10/2018 $104.00 67949 322 67838 LAS1 9/20/2018 68252 9/12/2018 67949 $50.00 363 PIS4 9/21/2018 67949 9/21/2018 9/14/2018 867 VR39 $88.00 68868 WA33 68979 9/17/2018 826 67949 9/21/2018 $126.00 68252 DIss 9/24/2018 $50.00 SA44 9/24/2018 $200.00 68868 AC65 68979 9/27/2018 $77.00 DA11 9/27/2018 $970.00 68979 Tasks TaskID Description Category Price AC65 Accessories ACC $80.00 DA11 Data recovery major Data recovery minor Hardware major DRM $175.00 Diss DRM $50.00 63 $225.00 Hardware minor H1 $165.70 LAS1 Local area networking (LAN) Mobility LAN S104.00 MO49 MOB $65.00 OT99 Other work $99.99 PIS4 Printing issues PRI $50.00 Software major SA44 SOM $200.00 S177 Software minor $144.00 SOM S191 Security install/repair Upgrades Virus removal SIR $126.00 UP38 UPG $185.00 VR39 VIR $90.00 WA33 Wide area networking (WAN) Web connectivity WAN $130.00 WC19 WEC $75.00