For the KimTay Pet Supplies database. Include both SQL commands and screenshots of SQL results in your answers. Find the ID, first name, and last name of each customer that currently has an invoice on file for Wild Bird Food (25 lb).List the item ID, description, unit price, and category for each item that has a unit price greater than the unit price of every item in category CAT. Use either the ALL or ANY operator in your query. (Hint: Make sure you select the correct operator.) CUSTOMERCUST_FIRST_ID126 Joey182227294375492NAME314 Tom543616BillySandra435 James05101520MelanieSamantha SmithElmerAngieSally721 Leslie795 RandyLAST_NAMESmithRuftonPincherRascalJacksonGonzalezJacksonCruzADDRESS17 Fourth St21 Simple CirSmith53 Verde Ln22 JacksonFarm RdHendricks 27 Locklear In14 Rock Ln1 Rascal FarmRd199 18th Ave123 SheeplandRdBlacksmith 75 Stream RdSALES REPREP_ID FIRST NAME LAST NAME ADDRESSSusanRichardGarciaMillerSmithJacksonDonnaDanielCITYCodyGarland42 BlackwaterWay16 Rockway Rd WapitiPowellRalstonCodyElk ButteGarlandPowellRalstonElk ButteCodySTATE POSTAL EMAILWYWYWYWYWYWYWYWYWYWY82414824358244082440824148243382450824358244082440WY 82433WY 82414CITY42 Mountain Ln Cody WY87 Pikes DrRalston WY312 Oak Rd Powell WY19 Lookout DrElk Butte WYjsmith 17@example.combillyruff@example.comspinch2@example.comssmith5@example.comtrascal3@example.commjackson5@example.comjgonzo@example.comejackson4@example.comBALANCE CREDIT_REPLIMIT ID$80.68$500.00 05Ismith12@example.com$43.13 $750.00 10$156.38 $500.00 15$58.60$17.25 $250.00 15$500.00 10$252.25 $250.00 05$230.40 $1,000.00 15$45.20 $500.00 10ahendricks7@ $315.00 $750.00 05example.comscruz5@example.com$8.33 $500.00 15$166.65 $1,000.00 10rblacksmith6@ $61.50example.comSTATE POSTAL CELL PHONE82414 307-824-1245824408244082433307-406-4321307-982-8401307-883-9481$500.00 05COMMISSION RATE$12,743.16 0.04$20,872.11 0.06$14,912.92 0.04$0.00 0.04 ITEMITEM_IDAD72BC33CA75DT12FM23FS39FS42KH81LD14LP73PF19QB92SP91UF39WB49DESCRIPTIONDog Feeding StationFeathers Bird Cage (12x24x18)Enclosed Cat Litter StationDog Toy Gift SetFly Mask with EarsFolding Saddle StandAquarium (55 Gallon)Wild Bird Food (25 lb)Locking Small Dog DoorLarge Pet CarrierPump & Filter KitQuilted Stable BlanketSmall Pet CarrierUnderground Fence SystemInsulated Water BucketFIGURE 1-2 Sample data for KimTay Pet Supplies1421614219142221422414228142311423314237INVOICESINVOICE_NUM INVOICE_DATEON HAND12101527CUST_ID11/15/2021 12511/15/2021 22711/16/2021 29418211/16/202111/18/2021 43511/18/2021 12511/18/2021 43511/19/2021 6164112524142353218734FIGURE 1-2 Sample data forKimTay Pet Supplies (Continued)CATEGORYDOGBRDCATDOGHORHORFSHBRDDOGDOGFSHHORCATDOGHOR142161421914219142221422414228142281423114233142331423314237LOCATIONBBCLD14KH81FS42PF19UF39KH81QB92WB49LP73BCсAСABAсBACopyright 2021 Cengage Learning. All Rights Reserved. May not be copied, scanned, or duplicated, in whole or in part. Due to electronic rights, some third party content may be suppressed from the eBook and/or eChapter(s).itorial review has deemed that any suppressed content does not materially affect the overall learning experience. Cengage Learning reserves the right to remove additional content at any time if subsequent rights restrictions require itCIntroduction to Kim Tay Pet Supplies and StayWell Student Accommodation DatabasesINVOICE_LINEINVOICE_NUM ITEM_ID QUANTITYCA75AD72DT12PRICE$79.99$79.9932$39.99$39.994141121443$24.95$39.99$124.99$19.99$49.99$59.99$74.99$119.99$39.99$199.99$79.99QUOTED_PRICE$37.99$79.99$39.99$47.99$18.99$124.99$74.99$189.99$19.99$109.95$74.95$54.955

HI. You can check the query below

Answered: For the KimTay Pet Supplies database.…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

For the KimTay Pet Supplies database. Include both SQL commands and screenshots of SQL results in your answers.

Find the ID, first name, and last name of each customer that currently has an invoice on file for Wild Bird Food (25 lb).
List the item ID, description, unit price, and category for each item that has a unit price greater than the unit price of every item in category CAT. Use either the ALL or ANY operator in your query. (Hint: Make sure you select the correct operator.)