select orderid, min(unitprice), max(unitprice) from Order_Details group by orderid;
select orderid, shipvia, count(shipvia) from Orders group by shipvia


select shipvia, count(*) from Orders where year(orderdate)=1997 group by shipvia




select shipvia, count(*) as ile from Orders where year(orderdate)=1997 group by shipvia
order by ile desc
Limit 1

select productid, sum(quantity) from Order_Details group by productid
having sum(quantity)>1000







select orderid, count(orderid) from Order_Details group by orderid having count(*)>5




Wyświetl klientów dla których w 1998 r zrealizowano wiecej niż 8 zamówień (wyniki posortuj malejąco wg łącznej kwoty za dostarczenie zamówień dla każdego z klientów)


select orderid, count(orderid) from Order_Details group by orderid having count(*)>5;
select Customerid, count(*), sum(freight) as kwota from Orders where year(orderdate)=1998 group by Customerid having count(*)>8
order by kwota desc