[go: up one dir, main page]
Scribd
Upload
19 views1 page

Lec 70 SQL Practice

The document contains a series of SQL queries related to customers, orders, and products. It includes queries to find customers who have placed orders, those who haven't, and details about orders along with product information. Additionally, it provides methods to count orders per customer and display relationships between customers, products, and order dates.

Uploaded by

koulibalyhamam
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
19 views1 page

Lec 70 SQL Practice

The document contains a series of SQL queries related to customers, orders, and products. It includes queries to find customers who have placed orders, those who haven't, and details about orders along with product information. Additionally, it provides methods to count orders per customer and display relationships between customers, products, and order dates.

Uploaded by

koulibalyhamam
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

select * from Customers

select * from Orders

select * from Products

--1) Write an SQL query to find the names of customers who have placed an order.
select distinct CustomerName from customers c inner join Orders o on o.CustomerID =
c.CustomerID

--2) Find the list of customers who have not placed any orders.
select distinct CustomerName from Customers c left join Orders o on O.CustomerID =
C.CustomerID where o.OrderID is null

--3) List all orders along with the product name and price.
select distinct ProductName,Price from Orders o join Products p on o.ProductID =
p.ProductID

--4) Find the names of customers and their orders, including customers who haven't
placed any orders.
select distinct CustomerName,OrderID from Customers c left join Orders o on
o.CustomerID = c.CustomerID

--5) Retrieve a list of products that have never been ordered.


select distinct p.ProductID,ProductName from Products p left join Orders o on
p.ProductID = o.ProductID where o.OrderDate is null

--6) Find the total number of orders placed by each customer.


select customername,count(orderid) [Number of Orders] from Customers c inner join
Orders o on c.CustomerID = o.CustomerID
group by customername

--OR
select customername,count(orderid) [Number of Orders] from Customers c LEFT join
Orders o on c.CustomerID = o.CustomerID
group by customername

--7) Display the customers, the products they've ordered, and the order date.
Include customers who haven't placed any orders.
select distinct CustomerName,p.ProductID,ProductName,OrderDate
from Customers c left join Orders o on c.CustomerID = o.CustomerID left join
Products p on o.ProductID = p.ProductID

You might also like