ÇóÒ»SQLÓï¾ä - ÆäËûÊý¾Ý¿â¿ª·¢ / MySQL/Postgresql

ÓÐÒ»¶©µ¥±í
SQL code:
t_orders{
oid,
user_id,
booking_time
}


Óû§ÓµÓеĶ©µ¥Êý
SQL code:
select o.user_id, count(o.oid) as amount from t_orders o where booking_time between (time1, between2)
group by o.user_id order by amount

====================
user_id amount
10001 1
10002 1
10004 2
10003 3
10007 3
10009 3
10011 3
10005 5
10006 8
10008 8
10010 8

ÏÖÐèͳ¼ÆÓµÓж©µ¥ÊýÄ¿ÏàͬµÄÓû§Êý
Ï£Íû½á¹û£º
orderAmount users
1 2
2 1
3 4
5 1
8 3

Âé·³ÄÄλ°ïдÏÂÄܵóöÉÏÃæͳ¼Æ½á¹ûµÄSQL?

---

SQL code:

select tb.amount,count(*) users from
(select o.user_id, count(o.oid) as amount from t_orders o where booking_time between (time1, between2)
group by o.user_id) tb
group by tb.amount
order by tb.amount;

---

select amount,count(*) as users from 
(select o.user_id, count(o.oid) as amount from t_orders o where booking_time between (time1, between2)
group by o.user_id) t
group by amount
ord