Answered step by step
Verified Expert Solution
Question
1 Approved Answer
CUSTOMER table INVOICES table INVOICE_LINE table ITEM table SALES_REP table Task 5: Repeat Task 4 , but this time use the EXISTS operator in your
CUSTOMER table
INVOICES table
INVOICE_LINE table
ITEM table
SALES_REP table
Task 5: Repeat Task 4, but this time use the EXISTS operator in your answer.
Task 6: Find the ID, first name, and last name of each customer for which an invoice was not created on November 15, 2021.
Task 7: For each invoice, list the invoice number, invoice date, item ID, description, and category for each item that makes up the invoice.
Task 8: Repeat Task 7, but this time order the rows by category and then by invoice number.
CUST_ID FIRST_NAME LAST_NAME ADDRESS CITY STATE POSTAL EMAIL BALANCE CREDIT_LIMIT REP_ID 125 Joey Smith 17 Fourth St Cody WY 82414 jsmith17@example.com 80.68 500.00 05 182 Billy Rufton 21 Simple Cir Garland WY 82435 billyruff@example.com 43.13 750.00 10 227 Sandra Pincher 53 Verde Ln Powell WY 82440 spinch2@example.com 156.38 500.00 15 294 Samantha Smith 14 Rock Ln Ralston WY 82440 ssmith5@example.com 58.60 500.00 10 314 Tom Rascal 1 Rascal Farm Rd Cody WY 82414 trascal@example.com 17.25 250.00 15 375 Melanie Jackson 42 Blackwater Way Elk Butte WY 82433 mjackson5@example.com 252.25 250.00 05 435 James Gonzalez 16 Rockway Rd Wapiti WY 82450 jgonzo@example.com 230.40 1000.00 15 492 Elmer Jackson 22 Jackson Farm Rd Garland WY 82435 ejackson4@example.com 45.20 500.00 10 543 Angie Hendricks 27 Locklear Ln Powell WY 82440 ahendricks7@example.com 315.00 750.00 05 616 Sally Cruz 199 18th Ave Ralston WY 82440 scruz5@example.com 8.33 500.00 15 721 Leslie Smith 123 Sheepland Rd Elk Butte WY 82433 Ismith12@example.com 166.65 1000.00 10 795 Randy Blacksmith 75 Stream Rd Cody WY 82414 rblacksmith@example.com 61.50 500.00 05 INVOICE_NUM INVOICE_DATE CUST_ID 14216 2021-11-15 125 14219 2021-11-15 227 14222 2021-11-16 294 14224 2021-11-16 182 14228 2021-11-18 435 14231 2021-11-18 125 14233 2021-11-18 435 14237 2021-11-19 616 INVOICE_NUM ITEM_ID QUANTITY QUOTED_PRICE 14216 CA75 3 3 37.99 14219 AD72 2 2 79.99 14219 DT12 4 39.99 14222 LD14 1 47.99 14224 KH81 4 18.99 14228 FS42 1 124.99 14228 PF19 1 74.99 14231 UF39 2 2 189.99 14233 KH81 1 19.99 14233 QB92 4 109.95 14233 WB49 4 74.95 14237 LP73 3 54.95 ITEM_ID DESCRIPTION ON_HAND CATEGORY LOCATION PRICE AD72 Dog Feeding Station 12 DOG B 79.99 BC33 Feathers Bird Cage (12x24x18) 10 BRD B 79.99 CA75 Enclosed Cat Litter Station 15 CAT 39.99 DT12 Dog Toy Gift Set 27 DOG B 39.99 FM23 Fly Mask with Ears 41 HOR 24.95 FS39 Folding Saddle Stand 12 HOR C 39.99 FS42 Aquarium (55 Gallon) 5 FSH A 124.99 KH81 Wild Bird Food (25 lb) 24 BRD C 19.99 LD14 Locking Small Dog Door 14 DOG 49.99 LP73 Large Pet Carrier 23 DOG B 59.99 REP ID FIRST_NAME LAST_NAME ADDRESS CITY STATE POSTAL CELL PHONE COMMISSION RATE 05 Susan Garcia 42 Mountain Ln Cody WY 82414 307-824-1245 12743.16 0.04 10 Richard Miller 87 Pikes Dr Ralston WY 82440 307-406-4321 20872.11 0.06 15 Donna Smith 312 Oak Rd Powell WY 82440 307-982-8401 14912.92 0.04 20 Daniel Jackson 19 Lookout Dr Elk Butte WY 82433 307-883-9481 0.00 0.04Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started