找尋不重複使用者使用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’;