Dziękuje. Prosze usunąc post
0
0
Czy chodzi może o coś takiego?
select
c.CustomerID
,c.CompanyName
,cnt
,o.OrderID
,case when od.cnt >= 2 then 'Długie zamówienia' else 'Krótkie zamówienia' end as Info
from
(
select
OrderID
,sum(Quantity) as cnt
from [Order Details]
group by OrderID
) as od
inner join Orders o on o.OrderID = od.OrderID
inner join Customers c on o.CustomerID =c.CustomerID
order by cnt
Ewentualnie trochę inaczej:
select
c.CustomerID
,c.CompanyName
,cnt
,o.OrderID
,case when od.cnt >= 2 then 'Długie zamówienia' else 'Krótkie zamówienia' end as Info
from
(
select
OrderID
,count(distinct productid) as cnt
from [Order Details]
group by OrderID
) as od
inner join Orders o on o.OrderID = od.OrderID
inner join Customers c on o.CustomerID =c.CustomerID
order by c.CustomerID