Count the number of user events performed by MacBookPro users.

Count the number of user events performed by MacBookPro users.

题目类型: 技术面试题

这是一道技术面试题，常见于澳洲IT公司面试中。

难度: medium

分类: problem-solving

标签: Apple Data Science

目标岗位: Data Scientist

目标公司: Apple

参考答案摘要

回答要点：SQL join users→devices→events; filter device_model='MacBookPro'; aggregate COUNT(*) or COUNT(DISTINCT event_id) by user or overall.

本题提供 STAR 原则详细解答和技术解析，登录匠人学院学习中心即可查看完整答案。