思扣网SQLintern取数师能力测评

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

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

3分钟

完成测试

6题

精选题目

120分

满分挑战

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

(gender =' F' AND parent_bg = '公务员' AND total_score > 650 ) OR (chinese+math+english) > 300)
(gender =' F' ) AND (parent_bg = '公务员') AND (total_score > 650 OR (chinese+math+english) > 300)
gender =' F' OR parent_bg = '公务员' AND total_score > 650 OR (chinese+math+english) > 300
(gender =' F' ) AND (parent_bg like '%公务员_') AND (total_score > 650 OR (chinese+math+english) > 300)

SELECT SUBSTRING_INDEX(email, '@', 1) AS domain FROM employees;
SELECT RIGHT(email, LENGTH(email) - LOCATE('@', email)) AS domain FROM employees;
SELECT SUBSTRING_INDEX(email, '@', -1) AS domain FROM employees;
SELECT SUBSTR(email, LOCATE('@', email)) AS domain FROM employees;

a	b	c
3	2	2
2	2	3

SELECT s.name FROM students s, scores sc, courses c
WHERE s.id = sc.student_id AND sc.course_id = c.id AND c.name = '数学' AND sc.score > 80;
SELECT s.name FROM students s
WHERE EXISTS (SELECT 1 FROM scores sc JOIN courses c ON sc.course_id = c.id WHERE sc.student_id = s.id AND c.name = '数学' AND sc.score > 80);
SELECT s.name FROM students s
JOIN scores sc ON s.id = sc.student_id
JOIN courses c ON sc.course_id = c.id
WHERE c.name = '数学' AND sc.score > 80;
SELECT s.name FROM students s
WHERE s.id IN (SELECT sc.student_id FROM scores sc WHERE sc.score > 80 AND sc.course_id IN (SELECT id FROM courses WHERE name = '数学'));

DENSE_RANK() OVER (PARTITION BY employee_id, MONTH(sale_date) ORDER BY sale_amount DESC)
RANK() 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)
ROW_NUMBER() OVER (PARTITION BY employee_id, MONTH(sale_date) ORDER BY sale_amount DESC)