Question

Some of my codes are showing errors, please help!

1. Create a view called NumCustomerOrders which lists all the customers and the
number of orders they have placed. Be sure to list the customer even if they have
not placed an order. (91 records) "

CREATE VIEW NumCustomerOrders AS
SELECT cust.CustomerName, COUNT()
FROM Customers cust
LEFT JOINS Order ord ON ord.OrderID = cust.CustomerID
WHERE Orders.OrderID IS NULL;

2. Create list of products that were shipped to customers on 04/18/2012. (4 Records) */

SELECT

INNER JOINS Order_Details ord ON pro.ProductID = ord.ProductID

INNER JOINS Order order ON ord.OrderID = order.OrderID

where order.ShippedDate = '2012-04-18';

Answer 1

1) Correct Query:

CREATE VIEW NumCustomerOrders AS
SELECT cust.CustomerName, COUNT(ord.OrderId)
FROM Customers cust
LEFT JOIN Orders ord ON ord.CustomerId = cust.CustomerID
GROUP BY cust.CustomerID

2)

Number of Records: 91 CustomerName COUNT(ord.OrderId) Alfreds Futterkiste Ana Trujillo Emparedados y helados Antonio Moreno Taquería Around the Horn Berglunds snabbköp Blauer See Delikatessen Blondel père et fils Bólido Comidas preparadas Bon app' Bottom-Dollar Marketse B's Beverages Cactus Comidas para llevar Centro comercial Moctezuma

Correct Query

SELECT ProductName FROM Products pro

INNER JOIN Order_Details ord ON pro.ProductID = ord.ProductID

INNER JOIN Order orde ON ord.OrderID = orde.OrderID

where orde.ShippedDate = '2012-04-18';

if you like the answer please provide a thumbs up.