My favorites | Sign in
Project Home Downloads Wiki Issues Source
READ-ONLY: This project has been archived. For more information see this post.
Search
for
ListaZapytanSQL  
Updated Feb 4, 2010 by kayn...@gmail.com

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

Powered by Google Project Hosting