Question: What are the sql queries for a, b, and c? the database has already been created. a) Produce list of all product names and number

What are the sql queries for a, b, and c? the database has already been created.

a) Produce list of all product names and number of different customers who have ordered the product

b) Produce list of all product names and number of orders that have included the product

c) Produce list of product names and number of orders when at least quantity of 2 was ordered.

What are the sql queries for a, b, and c? the database

Productlt ProductName ProductNumber ProductLine ProductClass SALES ORDERS CUSTOMER SalesOrderNumber CustomerID OrderDate DueDate ShipDate SubTotal TaxAmt Freight TotalDue CustomerID CustomerType AddressLinel AddressLine2 Product Color PostalCode ProductlistPrice ProductSize ProductSizeUnitMeasureCode Productweight ProductWeightUnitMeasureCode ORDER_DETAILS SalesOrderDetailID SalesOrderNumber ProductID OrderQty UnitPrice UnitPriceDiscount LineTotal

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Please, I am using APEX ORACLE as the platform to write queries . ESPECIALLY QUESTION 9 IS VERY DIFFICULT. Write SQL queries to answer the following questions: 1 . List the total number of customers....

1. Assume the following table- Degree (degcode, name, subject) Candidate (seatno, degcode, name, semester, month, year, result) Marks (seatno, degcode, semester, month, year, papcode, marks) [degcode...

Modify this JAVA code to meet these requirements: When your application starts, it reads a customer name and password from the command line. It validates them against the database and retains the...

The vegetable database: You have to create a database for use by the employees of vegetables.com, an online store which sells many dierent vegetables, including onions, tomatoes, carrots, potatoes,...

Assignment 4 is to use SQL queries to obtain appropriate data from databases for betting decision making. In this assignment, you will be asked to write SQL queries to get relevant information from...

MYSQL code Ecommerce Application Description This project involves using various Database concepts to solve E - commerce business use cases. This requires skills like Database concepts, SQL Queries,...

As pollution is increasing, som large cities have started a project called car sharing to reduce the number of cars in the city and also reduce the cost of having a car available when needed by a...

ANSWER Q4, HAVE INCLUDED ALL PARTS FOR REFERENCE BUT JUST ANSWER QUESTION 4: SQL QUERIES Question 1 (5 Points): Creating the database: Create a database using your name. Then create the following...

Presented below are a number of independent situations. Instructions For each individual situation, determine the amount that should be reported as cash. If the item(s) is not reported as cash,...

St. Vincent's Hospital has a target capital structure of 40 percent debt and 60 percent equity. Its cost of equity (fund capital) estimate is 13 percent and its cost of tax-exempt debt estimate is 7...

At Baliantine foating inc, a team of IT workers uses applied math to help the company budget advertising dollars across its entire market. The formulas these employees use indicate the optimal ways...