题解 | VQ22 #判断其是否有过购买记录#
判断其是否有过购买记录
https://www.nowcoder.com/practice/5cddad8995974b0c915ab89961428ee0
/* 判断客户是否有购买记录 */
SELECT
customer_id,
-- 如果客户有最新的下单日期，则标记为1，否则为0
CASE
WHEN latest_place_order_date IS NOT NULL THEN 1
ELSE 0
END AS if_placed_order
FROM
customers_info
;
查看7道真题和解析