Question: Create SQL queries for the following desired information from the schema below: - List the name and contact information for suppliers in Nebraska (NE). -
Create SQL queries for the following desired information from the schema below:
- List the name and contact information for suppliers in Nebraska (NE).
- List all of the employees who are managed by Katy Reasoner.
- Are male dogs more likely to be registered than the females?
- Does the store have more money tied up in inventory (quantity on hand) for dog items or cat items?
- Which employee sold the most quantity of items in March?

Animal AdoptionGroup AdoptionID AdoptionSource Contact Name Contact Phone Breed Category Breed Animali Name Category Breed DateBorn Gender Registered Color Photo ImageFile Imageheight Image Width AdoptionID SaleID Donation Category Category Registration Supplier Supplieri Name Contact Name Phone Address ZIP Code CityID Employee Employee Last Name FirstName Phone Address ZIP Code CityID TaxpayerID Date Hired Date Released Manageri EmployeeLevel Title City CityID ZIP Code City State AreaCode Population 1990 Population 1980 Country Latitude Longitude Sale Customer SaleID SaleDate Employeeld Customer Sales Tax CustomerID Phone First Name Last Name Address ZIP Code CityID Orderitem MerchandiseOrder PONumber Order Date ReceiveDate SupplierID Employeeld Shipping Cost PONumber Itemid Quantity Cost Merchandise Itemid Description QuantityOn Hand List Price 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
