задание 3 одним запросом

0

Please login or register to vote for this query.

(click on this box to dismiss)

Motor Vehicle Maintenance and Repair Meta

Q&A about the site for mechanics and DIY enthusiast owners of cars, trucks, and motorcycles

select distinct count(*) over (partition by case when count(p.id) < 10 then 0
                         when count(p.id) >= 10 and count(p.id) <= 20 then 1
                         when count(p.id) > 20 then 2 end)
from Posts as p
left join Users as u
on u.id = p.OwnerUserId
group by u.id

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results