Tutaj dopisujemy liste zapytan, ktore posłużą do testowania generatora wykresów.
TOP 10 klientow (najwiecej wydali):
SELECT c.customerName, SUM(p.amount) as total FROM customers c NATURAL JOIN payments p GROUP BY c.customerName ORDER BY total LIMIT 10
TOP 10 produktow (zajwiecej zamowien):
SELECT p.productName, SUM(o.quantityOrdered) as total FROM products p NATURAL JOIN orderdetails o GROUP BY p.productCode ORDER BY total DESC LIMIT 10
Przychód z poszczególnych lat: SELECT YEAR(paymentDate), SUM(amount)as income FROM payments GROUP BY YEAR(paymentDate) ORDER BY paymentDate DESC