Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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 Category

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases DeMYSTiFieD

Authors: Andy Oppel

2nd Edition

0071747990, 978-0071747998

More Books

Students also viewed these Databases questions