SQL語法練習

找尋不重複使用者使用iphone && os_version >= “14″:
SELECT DISTINCT user_id FROM cloud.record WHERE device_type like “iPhone%" AND os_version >= “14″;

找尋不重複使用者使用iphone && os_version >= “14″ && start_original > ‘2022-06-01’ (i.e. 3個月內有活動紀錄的人):
SELECT DISTINCT user_id FROM cloud.record WHERE device_type like “iPhone%" AND os_version >= “14″ AND start_original > ‘2022-06-01’;