Postgresql select join sort by count

Question

I have two tables.

Goods:

                          Table "public.goods"
     Column      |           Type           |         Modifiers         
-----------------+--------------------------+---------------------------
 goods_id        | character varying        | not null
 goods_owner_id  | character varying        | not null

Sellers:

                          Table "public.sellers"
     Column      |           Type           |         Modifiers         
-----------------+--------------------------+---------------------------
 sellers_id      | character varying        | not null
 sellers_name    | character varying        | not null

How to make a request that will show sellers with the most quantity of goods? Thank you.

Does public.goods table has foreign key constraint that references sellers_id column of public.sellers? — Grigoriy Mikhalkin
– Grigoriy Mikhalkin, Commented Apr 25, 2018 at 20:29

Grigoriy Mikhalkin · Accepted Answer · 2018-04-25 20:42:25Z

1

Here is sql query:

SELECT sellers.sellers_id 
    FROM goods JOIN sellers ON goods.goods_owner_id = sellers.sellers_id
    GROUP BY sellers.sellers_id
    ORDER BY COUNT(goods.goods_id) DESC 
    LIMIT 1

answered Apr 25, 2018 at 20:42

Grigoriy Mikhalkin

5,7032 gold badges22 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql select join sort by count

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related