SQL basics -GROUP BY from THENEWBOSTON

Instruction: Give me the seller ID and number of items from each seller who listed 3 or more items arranged from highest to lowest. 

SELECT seller_id, count(*) AS item_count 

FROM items 

GROUP BY seller_id 

HAVING COUNT(*)>=3

ORDER BY item_count DESC

source: https://youtu.be/GjjU6gdfXzc