Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Access 2016 I have these tables I wnat to make QUERIES: Query 2: Based on the Inventory table, what is the gross profit per pound

Access 2016

I have these tables

image text in transcribed

I wnat to make QUERIES:

Query 2: Based on the Inventory table, what is the gross profit per pound per product?

Query 3: How many customers does the company have per state.

Query 4: Count the number of sales and total dollar sales for every salesperson.

Query 5: Which two Employees have generated the most sales for February?

Query 6: What is the total Quantity sold in pounds for every product and what is the remaining inventory balance on hand also in in pounds

Query 7. What are the total sales per state for the month of February?

---

what are the steps?

Customer Employee Inventory Sales Customer Number Customer_Name Address Employee Number Last_Name First Name Hire Date Status Invoice Number description Unit Cost Unit Price Quantity on Hand SDate Employee Number Customer Number Amount State Credit Limit Sales_Inventory Invoice Number Item Number Quantity

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

Oracle 10g SQL

Authors: Joan Casteel, Lannes Morris Murphy

1st Edition

141883629X, 9781418836290

More Books

Students also viewed these Databases questions

Question

What could motivate staff to participate?

Answered: 1 week ago