Mysql题目查询购买了全部商品的id，根据分数进行排名次

1、有两张表customer 和 product,查询有 product 表中两个商品的 customer_id

SELECT *
FROM  (SELECT DISTINCT customer_id FROM customer)a
WHERE NOT EXISTS(
  SELECT product_key
  FROM product b
  WHERE NOT EXISTS(
     SELECT *
     FROM customer c
     WHERE b.product_key = c.product_key AND a.customer_id=c.customer_id)
) 

 

2、有表t4 如图，得出结果如图

SELECT t.a,t.b+t1.b AS b,
 IF(t.c=t1.c,t.c,1) as c