Hi Everybody; please, I need the answers for those questions as soon as possible
ID: 3672680 • Letter: H
Question
Hi Everybody;
please, I need the answers for those questions as soon as possible and I want it to be written to make it easy to copy for me, not being as pictures.
the first part of the questions:
the second part of the questions:
please, give the label and the number for each answer in order.
Best Regards,
OrderLine lineld orderId item quantity price 58.00 OrderMaster orderld customerId order_date 30-Jun-2015 30-Jun-2015 1111210101 Customer customerId firstname lastname city sta 10101 John Gray Lynden Washi Brown Pinetop ArizoExplanation / Answer
1)a)
SELECT
Orders.OrderID, Orders.CustomerID, Orders.EmployeeID, Orders.OrderDate, Orders.RequiredDate, Orders.ShippedDate, Orders.ShipVia, Orders.Freight, Orders.ShipName, Orders.ShipAddress, Orders.ShipCity, Orders.ShipRegion, Orders.ShipPostalCode, Orders.ShipCountry,
Customers.CompanyName, Customers.Address, Customers.City, Customers.Region, Customers.PostalCode, Customers.Country
FROM Customers
INNER JOIN Orders
ON Customers.CustomerID = Orders.CustomerID;
1)b)
SELECT Categories.CategoryID, Categories.CategoryName, Products.ProductName, Sum([Order Details Extended].ExtendedPrice) AS ProductSales
FROM Categories
INNER JOIN (Products
INNER JOIN (Orders
INNER JOIN [Order Details Extended]
ON Orders.OrderID=[Order Details Extended].OrderID)
ON Products.ProductID=[Order Details Extended].ProductID)
ON Categories.CategoryID=Products.CategoryID
WHERE (((Orders.OrderDate) Between #1/1/1997# And #12/31/1997#))
GROUP BY Categories.CategoryID, Categories.CategoryName, Products.ProductName
ORDER BY Categories.CategoryName;
2)a)select d.name , count(t.name) frim teacher.t JOIN dept ON t.dept=d.id group by order by t.name
b)