Question: I need help on this database SQL questions refer to the table given. Thank you 1. PetStore: How many cats were sold in February 2.
I need help on this database SQL questions refer to the table given. Thank you
1. PetStore: How many cats were sold in February
2. List the suppliers in Kentucky that sold us fish
3. PetStore: Which employees ordered merchandise from suppliers in Tennessee in April. Make sure to eliminate any duplicate employee results.


AdoptionGroup Animal AdoptionlD AdoptionSource ContactName ContactPhone 0 AnimalID Breed DateBorn Category Registered Employee EmployeelD LastName FirstName Category Category Registration ty Supplier SupplierlD ContactName 2 Imageheight ImageWidth ZIPCode one SalelD Donation AreaCode Population1990 Population1980 TaxPayerlD DateHired DateReleased ManagerlD EmployeeLevel SalelD SaleDate EmployeelD CustomerlD Customer CustomerlD Phone FirstName LastName Latitude Longitude ress ZIPCode MerchandiseOrder PONumber OrderDate ReceiveDate SupplierlD EmployeelD ShippingCost Orderltem PONumber ItemlD Merchandise Saleltem SalelD ItemID Description QuantityOnHand ListPrice SalePrice Customer TubeMaterial BikeTubes ModelType Tube Name Component Groupl Paint ColorStyle Totallength WaterBottleBr azeOn HeadTubeAngle Manufact urerlD CustomerTrans Category LetterStylelD Datelnstalled TransactionDate StorelD ZIPCode CitylD Quantity Received ReceiveDate Manufacturer Manufacturer Trans WorkArea Manufactu rerlD Manufacturer Name Description ZIPCode AdoptionGroup Animal AdoptionlD AdoptionSource ContactName ContactPhone 0 AnimalID Breed DateBorn Category Registered Employee EmployeelD LastName FirstName Category Category Registration ty Supplier SupplierlD ContactName 2 Imageheight ImageWidth ZIPCode one SalelD Donation AreaCode Population1990 Population1980 TaxPayerlD DateHired DateReleased ManagerlD EmployeeLevel SalelD SaleDate EmployeelD CustomerlD Customer CustomerlD Phone FirstName LastName Latitude Longitude ress ZIPCode MerchandiseOrder PONumber OrderDate ReceiveDate SupplierlD EmployeelD ShippingCost Orderltem PONumber ItemlD Merchandise Saleltem SalelD ItemID Description QuantityOnHand ListPrice SalePrice Customer TubeMaterial BikeTubes ModelType Tube Name Component Groupl Paint ColorStyle Totallength WaterBottleBr azeOn HeadTubeAngle Manufact urerlD CustomerTrans Category LetterStylelD Datelnstalled TransactionDate StorelD ZIPCode CitylD Quantity Received ReceiveDate Manufacturer Manufacturer Trans WorkArea Manufactu rerlD Manufacturer Name Description ZIPCode
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
