文章目录 题目代码(7.14 首刷看解析) 题目 Leetcode 1581. 进店却未进行过交易的顾客 代码(7.14 首刷看解析) 左连接,找出NULL值 # Write your MySQL query statement below select customer_id, count(1) as count_no_trans from Visits as v left join Transactions as t on v.visit_id = t.visit_id where transaction_id is NULL group by customer_id;