SQL dotaz, zkouska 25.5.2023

select o.idOrder, count(*)
from "order" o
join store s on s.idStore = o.idStore
join OrderItems oi on oi.idOrder = o.idOrder
where s.residence = 'Praha' and o.order_datetime > '2000-01-01' and o.order_datetime < '2020-12-31' and oi.quantity < 2
group by o.idOrder
option(maxdop 1)