Question

SQL help (all parts are related to each other so please answer them all, thank you!)

https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all

A.Find the number of suppliers for each of the product category
B.Find the totalprice for each order, sort them based on pricein descending order
C.Find the category name and description for each product in Table Products
D.Find the EmployeeID who has the highest order amount(e.g. the total dollar amount for an order)in July 1996
E.Find the top three countries whereconsumers purchased the most(e.g. the total dollar amount for all orders placed for goods originatedfrom a country)in all periods

Answer 1

A.
SELECT Categories.CategoryName, count(*) as count
FROM Products, Categories
where Categories.CategoryID = Products.CategoryID
group by Categories.CategoryName, Products.CategoryID

B.

SELECT Orders.OrderID, sum(OrderDetails.Quantity * Products.Price) as Total

FROM Orders, OrderDetails, Products

where Orders.OrderID = OrderDetails.OrderID
and OrderDetails.ProductID = Products.ProductID

group by Orders.OrderID
order by total desc

C.
SELECT Categories.CategoryName, Categories.Description, Products.ProductName
FROM Categories, Products
where Categories.CategoryID = Categories.CategoryID

Answering first 3 questions, as queries are taking a lot of time, and they are detailed queries, not simple select statements.