题解 | #判断其是否有过购买记录#
判断其是否有过购买记录
https://www.nowcoder.com/practice/5cddad8995974b0c915ab89961428ee0
SELECT customer_id, CASE WHEN latest_place_order_date IS NOT NULL THEN 1 WHEN latest_place_order_date IS NULL THEN 0 END AS if_placed_order FROM customers_info