题解 | #判断其是否有过购买记录#

判断其是否有过购买记录

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

全部评论

相关推荐

点赞 收藏 评论
分享
牛客网
牛客企业服务