Question: What are the sql queries for the following based on the tables? a) Produce list of product names that have never been ordered b) Produce

What are the sql queries for the following based on the tables?

a) Produce list of product names that have never been ordered

b) Produce list of customer id that have never placed any orders

c) Produce list of all customer id, and number of different products they have ordered (sorted descending order by number of different products)

What are the sql queries for the following based on the tables?

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!

Consider the relations: Customer(BID, Name, City, State), Order(RID, BID, Date), and Product(AID, ProductName, Price) LineItem(IID, RID, AID, Number, TotalPrice), where BID is a customer id and is a...

uery Name Description Query 1 Retrieve client information for Jill Klein. List the client ID, client name, st ate and zip code for the clientname of " Jill K lein " . (Note: you need to enclose "...

Fundamentals of Analytics and Business Intelligence Maximum Score: 25 Points Please answer all questions in the space provided and submit your solutions on Blackboard by 11:59 pm on October 10. Late...

Part 1) Queries with Relational Algebra This part is to get you familiar with expressing queries in Relational Algebra and to further familiarize you with the tables used to implement the telephone...

SQL Queries Create the following SQL Server queries that access the SQL Server Northwind database. Place them in a zip file and place the zip file in the Digital Drop Box. Name the queries...

Write the SQL queries using the database defined. -- Use Northwind Database /* 1. For each product list its name, unit price, and how many units we have in stock. */ /* 2.List the product name and...

This part is to get you familiar with expressing queries in Relational Algebra and to further familiarize you with the tables used to implement the telephone switching database from assignment #2....

(Writing SQL queries) The local bar, Petes Bar, maintains a database with the following tables, Customers (Email, Name, Age) Beers (ID, Name, Time, Brewery, Price) Orders (Email, ID, Date) Answer the...

All-Pro Sporting Equipment Inc. (referred to as ASPE or APSE Inc.) is a local success story. Operating out of Etobicoke, the company designs, manufactures, and sells specialized equipment for...

DATABASE PROGRAMMING - WRITE THE SQL QUERIES FOR THE FOLLOWING QUESTIONS CREATE TABLE dept ( deptno NUMBER(2,0), dname VARCHAR2(14), loc VARCHAR2(13), CONSTRAINT n_pk_dept PRIMARY KEY (deptno) );...

Ron Barber, CPA, is auditing the financial statements of DGF, Inc., a publicly held company. During the course of the audit, Barber discovered that DGF has been making illegal bribes to foreign...

What is a bond with an embedded option?

Specific performance is an equitable remedy that is typically not available when a seller breaches a contract for the sale of land, because land is not deemed to be unique and the payment of monetary...

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

2. What technologies are used by UPS? How are these technologies related to UPSs business strategy? United Parcel Service (UPS) started out in 1907 in a closet-sized basement office. Jim Casey and...

2. Identify the problems that businesses in this case study solved by using mobile digital devices. How much of your job can you do from the palm of your hand? Probably more than you think. Today...

1. What kinds of applications are described here? What business functions do they support? How do they improve operational efficiency and decision making? How much of your job can you do from the...