题目：1581.进店却未进行过任何交易的顾客

​​题目来源：

        leetcode题目，网址：1581. 进店却未进行过交易的顾客 - 力扣（LeetCode）

解题思路：

       对于每一个顾客，其到店次数与到店未交易次数之差即为所求。

解题代码：

# Write your MySQL query statement below
select d.customer_id, d.diff as count_no_trans
from (select  customer_id,count(a.visit_id)-count(b.visit_id) as diff
    from visits as a left join (select distinct visit_id from transactions) as b on a.visit_id=b.visit_id
    group by a.customer_id) as d
where   d.diff!=0;

总结：

        没有官方题解，我的代码写的好丑。

---