SQL dotaz, zkouska 25.5.2023, II

select o.idOrder, count(*)
from "order" o
join OrderItems oi on oi.idOrder = o.idOrder
join product p on p.idProduct = oi.idProduct
where year(o.order_datetime) = 2000 and oi.unit_price between 10000 and 12000 and producer LIKE 'O%'
group by o.idOrder
option(maxdop 1)