思扣网SQLintern取数师能力测评

马上就要面试了
你到底行不行

开始测试，了解你的SQL真实水平，找到提升方向！

3分钟

完成测试

6题

精选题目

120分

满分挑战

注意：本页面为不定项选择题，共6题，全部答对20分，答对部分10分，选错、选多0分；满分120分。

SELECT u.user_id, IFNULL(SUM(oi.quantity * oi.price), 0) AS total
FROM users u
LEFT JOIN orders o ON u.user_id = o.user_id
LEFT JOIN order_items oi ON o.order_id = oi.order_id
GROUP BY u.user_id;
SELECT u.user_id, SUM(IFNULL(oi.quantity * oi.price, 0)) AS total
FROM users u
LEFT JOIN orders o ON u.user_id = o.user_id
LEFT JOIN order_items oi ON o.order_id = oi.order_id
GROUP BY u.user_id;
SELECT u.user_id, SUM(oi.quantity * oi.price) AS total
FROM users u
LEFT JOIN orders o ON u.user_id = o.user_id
LEFT JOIN order_items oi ON o.order_id = oi.order_id
GROUP BY u.user_id;
SELECT u.user_id, SUM(oi.quantity * oi.price) AS total
FROM users u, orders o, order_items oi
WHERE u.user_id = o.user_id AND o.order_id = oi.order_id
GROUP BY u.user_id;

RANK() OVER (PARTITION BY employee_id, MONTH(sale_date) ORDER BY sale_amount DESC)
DENSE_RANK() OVER (PARTITION BY employee_id, MONTH(sale_date) ORDER BY sale_amount DESC)
ROW_NUMBER() OVER (PARTITION BY employee_id, MONTH(sale_date) ORDER BY sale_amount DESC)
DENSE_RANK() OVER (PARTITION BY MONTH(sale_date) ORDER BY sale_amount DESC)