题解 | #判断其是否有过购买记录#
判断其是否有过购买记录
https://www.nowcoder.com/practice/5cddad8995974b0c915ab89961428ee0
select customer_id, (case when latest_place_order_date is not null then 1 else 0 end) as 'if_placed_order' from customers_info
注意case when***then***else***end,中间没有任何符号