Task 5 List the customer ID, the first name, and the last name of each customer represented by sales rep 10 or sales rep 15 Task 6 List the item ID and description of each item that is not in category HOR Task 7 List the item ID, description, and number of units on hand for each item that has between 10 and 30 units on hand, including both 10 and 30 Task 8 List the item ID, description, and on hand value (units on hand unit price) of each item in category CAT (On hand value is technically units on hand cost, but there is no COST column in the ITEM table) Assign the name ON HAND VALUE to the computed column 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 jsmith 17 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 igonzo 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 In 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 37 99 14219 AD72 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 N 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 A 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 04

Question

Task 5  List the customer ID, the first name, and the last name of each customer represented by sales rep 10 or sales rep 15   Task 6  List the item ID and description of each item that is not in category HOR  Task 7  List the item ID, description, and number of units on hand for each item that has between 10 and 30 units on hand, including both 10 and 30   Task 8  List the item ID, description, and on hand value (units on hand   unit price) of each item in category CAT  (On hand value is technically units on hand   cost, but there is no COST column in the ITEM table)  Assign the name ON HAND VALUE to the computed column  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 jsmith 17 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 igonzo 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 In 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 37 99 14219 AD72 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 N 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 A 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 04

Accepted Answer

The Answer is in the image, click to view ...

Question

Task 5: List the customer ID, the first name, and the last name of each customer represented by sales rep 10 or sales rep 15

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Select Healthcare Classification Systems And Databases

Students also viewed these Databases questions

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question

Question