Question
For the following db schema, answer the below questions using SQL queries. 1. List all of the cats that are not registered. =================================== 2. Which
For the following db schema, answer the below questions using SQL queries.
1. List all of the cats that are not registered.
===================================
2. Which supplier was paid the most amount of money?
=====================================================
3. Based on customer address, in which state did the store sell the most merchandise in the first half of the year?
=====================================================
4. Who was the best salesperson of merchandise in January?
=====================================================
5. Which adoption group had the most animals actually adopted from January through May?
=====================================================
6. List the merchandise sales by category and show the percentage of the total.
=====================================================
7. Which suppliers have sold both dog and cat merchandise?
Adoption Group AdoptionID AdoptionSource ContactName Contact Phone Breed Category Breed Animal Animali Name Category Breed DateBorn Gender Registered Color Photo ImageFile Imageheight ImageWidth AdoptionID SalelD Donation City Category Category Registration Supplier SupplierID Name Contact Name Phone Address ZIP Code CityID Employee Employeeld LastName FirstName Phone Address ZIP Code CityID TaxPayerID Date Hired Date Released ManagerID EmployeeLevel Title CityID ZIP Code City State AreaCode Population 1990 Population 1980 Country Latitude Longitude Sale SalelD SaleDate Employeeld Customer Sales Tax Customer CustomerID Phone FirstName LastName Address ZIP Code CityID MerchandiseOrder PONumber OrderDate ReceiveDate SupplierlD Employeeld Shipping Cost Orderitem PONumber ItemID Quantity Merchandise ItemID Description QuantityOnHand ListPrice Category Saleltem SalelD ItemID Quantity Sale Price Cost breed Category VARCHAR(50) Breed VARCHAR(50) Indexes sale adoptiongroup Adoption ID INT Adoption Source VARCHAR(255) ContactName VARCHAR(255) ContactPhone VARCHAR(255) Indexes preterences KeyID VARCHAR(50) Value VARCHAR(50) Description VARCHAR(90) Indexes SaleID INT SaleDate DATETIME EmployeeID INT CustomerID INT Sales Tax DECIMAL (19,4) Indexes 1 1 employee Employee INT Last Name VARCHAR(50) insame VARCHAR(50) Phone VARCHAR(50) Ackless VARCHAR(50) ZipCode VARCHAR(50) CRYID INT - Tax PayerID WROHAR/50) Date Hired DATETIME Date Released DATETIME ManageID INT Employeelev TINYINT The VARCHAR(50) Indexes orderitem animal Y 5 1... + PONumber INT Item ID INT Quantity FLOAT Cast DECIMAL 19.4) Indekes city CIVID INT Zip Code VARCHAR(50) CRY VARCHAR(50) State VARCHAR(50) Area Code VARCHAR(50) Population 1990 INT Population 1920 INT Country VARCHAR(50) Latitude FLOAT Longitude FLOAT Indexes merchandise ItemID INT Description VARCHAR(50) QuantityOn Hand INT ListPrice DEC MAL(19,4) Category VARCHAR(50) Indexes Anina ID INT Name VARCHAR(50) Category VARCHAR(50) Breed VARCHAR(50) Date Bon DATETIME Gender VARCHAR(50) Registered VARCHAR(50) Color VARCHAR(50) Photo LONGBLOS Imagefile VARCHAR (250) ImageHeight INT Image Width INT SaleID INT Adoption ID INT Donation DECIMAL (194) Indexes . 9.. $ saleitem SaleID INT ItemID INT Quantity INT Sale Price DECIMAL 19.4) Indexes 14 customer CustomerID INT > Phone VARCHAR(50) FirstName VARCHAR(50) Last Name VARCHAR(50) Address VARCHAR(50) LP Zip Code VARCHAR(50) ) CityID INT Indexes supplier Supplier ID INT > Name VARCHAR(50) ContactName VARCHAR(50) Phone VARCHAR(50) Ackless VARCHAR(50) Zip Code VARCHAR(50) CRYID INT Indexes E merchandiseorder autonumber Table Name VARCHAR(100) KeyValue INT Keyincrement INT Indexes PONumber INT Order Date DATETIME Receive Date DATETIME Supplier ID INT EmployeeID INT Shipping Cost DECIMAL19,4) Order Cast DECIMAL (9.4) Indexes revision Revision ID INT Version VARCHAR(50) Description LONGTEXT Author VARCHAR(255) Release Date DATETIME Indexes category Category VARCHAR(50) Registration VARCHAR(50) IndexesStep 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