Question: Answer the questions below by developing queries in SQL. Please input queries in SQL to make sure they answer the questions. 1. What was the

Answer the questions below by developing queries in SQL. Please input queries in SQL to make sure they answer the questions.
1. What was the percentage of sales value by merchandise category in March? 2. Which category of animal was most likely (percent) to be adopted in the first three months? This can be either the first three months of the year or three months after the birth.
Adoption Group AdoptionID AdoptionSource Contact Name Contact Phone Breed Category Breed Animal Animali Name Category Breed DateBorn Gender Registered Color Photo ImageFile Imageheight Image Width AdoptionID SalelD Donation Category Category Registration Supplier SupplierID Name Contact Name Phone Address ZIP Code CityID Employee Employeeld LastName First Name Phone Address ZIP Code CityID TaxPayerID Date Hired Date Released ManagerID EmployeeLevel Title City CityID ZIP Code City State AreaCode Population 1990 Population 1980 Country Latitude Longitude Sale SalelD SaleDate Employeeld CustomerID Sales Tax Customer CustomerID Phone FirstName LastName Address ZIP Code CityID MerchandiseOrder PONumber Order Date ReceiveDate SupplierID Employeeld Shipping Cost Orderltem PONumber ItemID Quantity Cost Merchandise ItemID Description QuantityOnHand ListPrice Category Saleltem SalelD ItemID Quantity Sale Price
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
