How to make this query on PostgreSQL?

Question

I have three tables:

Customer table

Product Table

Customer_Product Table

I need to make query: Search for customers who bought a certain product (for example, name = "toilet paper") at least 2 times I don't understand how.. I'm noob in databases.. Please help

Yogesh Sharma · Accepted Answer · 2020-03-19 10:30:01Z

1

You need aggregation :

select c.name
from customer c inner join
     customer_product cp
     on cp.customer_id = c.customer_id inner join
     product p
     on p.product_id = cp.product_id
where p.lable = 'toilet paper'
group by c.name
having count(p.lable) > 1;

answered Mar 19, 2020 at 10:30

Yogesh Sharma

50.2k5 gold badges31 silver badges53 bronze badges

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

Collectives™ on Stack Overflow

How to make this query on PostgreSQL?

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