Anzahl bestellte Artikel ausgeben.
SELECT SUM(Quantity) AS „Total Anzahl bestellte Artikel“ FROM OrderDetails
Anzahl Bestellmenge (Quatities) pro Land.
SELECT c.country, count(o.orderid) AS Anzahl , sum(od.quantity)
AS Anzahl_Quantities
FROM customers AS c
LEFT JOIN orders AS o ON o.customerid = c.customerid
LEFT JOIN orderdetails AS od ON od.orderid = o.orderid
GROUP BY c.country
ORDER BY Anzahl
Einnahmen pro Land.
SELECT c.country, COUNT(o.orderid) AS Anzahl , ROUND(SUM(od.quantity*p.price),2)
AS Einnahmen
FROM customers AS c
LEFT JOIN orders AS o ON o.customerid = c.customerid
LEFT JOIN orderdetails AS od ON od.orderid = o.orderid
LEFT JOIN products AS p ON p.productid = od.productid
GROUP BY c.country
ORDER BY Einnahmen DESC
