Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3 . We need a listing of all sales orders that have not been invoiced. Please show the order number, the order date, the customer

3. We need a listing of all sales orders that have not been invoiced. Please show the order number, the order date, the customer name, the expected shipping date, and the salesperson name for these un-invoiced sales orders.
4. We offer a standard discount to orders from auto parts stores. For such orders, the discount percentage for each product ordered is shown in the "products_ordered" table. I would like to know the combined sum total dollar value of the discounts for all product sales for which a discount was applied, that is, product sales orders to auto parts stores.
5. We need to determine the frequency of usage of each of the two shipping companies we use. How many orders are assigned (in the orders table) to the shipper UPS versus the shipper Tampa Tracking? A simple count for each will suffice.
Need the queries for those please

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

More Books

Students also viewed these Databases questions

Question

=+How should it be delivered?

Answered: 1 week ago

Question

=+4 How does one acquire a global mindset?

Answered: 1 week ago