Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Answer the questions below and please show how to input the queries in SQL: create queries, save the SQL syntax of all queries in one
Answer the questions below and please show how to input the queries in SQL:
create queries, save the SQL syntax of all queries in one text file, separate and mark with question number.
1. Which employee sold the most quantity of items in March?
2. List all of the employees who are managed by Katy Reasoner.
3. Are male dogs more likely to be registered than the females?
4. Does the store have more potential sales revenue (list price) in inventory (quantity on hand) for dog items or cat items?
AdoptionGroup Animal AdoptionlD AdoptionSource ContactName ContactPhone AnimaliD Category Breed Breed DateBorn Gender Registered Color Photo Category Breed City Category LastName FirstName Supplier GtylD Category Registration SupplierlD Name ContactName Phone City State AreaCode Population1990CitylD Population1980 Imageheight ImageWidth Adoption!D SaleID Donationn TaxPayerlD DateHired DateReleased ZIPCode Sale CitylD Country SalelD SaleDate EmployeelD CustomerlD Customer CustomerlD Phone FirstName LastName Address Latitude Managerld Employeelevel Title Longitude Saleltem SalelD ItemiD Quantity SalePrice MerchandiseOrder CitylD Orderltem PONumber ItemID Quantity Merchandise ItemID Description QuantityOnHand Lis Price PONumber SupplierlD EmployeelD ShippingCost CategoryStep 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