LeetCode1581. 进店却未进行过交易的顾客(sql)

最新推荐文章于 2024-08-31 21:00:27 发布

非风之想

最新推荐文章于 2024-08-31 21:00:27 发布

阅读量77

点赞数

分类专栏：题解文章标签： sql 数据库 mysql

本文链接：https://blog.csdn.net/hong66111/article/details/129847632

版权

题解专栏收录该内容

17 篇文章 0 订阅

订阅专栏

该文讨论了两种在MySQL中找出没有进行过购物的客户的方法：一是使用子查询，从Visits表中选择未在Transactions表中出现的visit_id；二是通过左连接，保留Transactions表中缺失的visit_id，从而计算未交易的客户计数。

摘要由CSDN通过智能技术生成

题目

思路

分组聚合（计数），过滤掉购物过的

题解

子查询

# Write your MySQL query statement below 
select customer_id, count(customer_id) as count_no_trans from Visits
    where visit_id not in (select visit_id from Transactions)
    group by customer_id;

左连接

# Write your MySQL query statement below 
select customer_id, count(customer_id) as count_no_trans from Visits as v
    left join Transactions as t on v.visit_id = t.visit_id
    where t.visit_id is null
    group by customer_id;