データ取得チャレンジ

SELECT * FROM employees WHERE department = '開発部';

SELECT name, salary FROM employees WHERE department = '開発部';

SELECT name salary FROM employees WHERE department = '開発部';

SELECT name AND salary FROM employees WHERE department = '開発部';

1, 2, 3, 4

2 のみ

2, 4

1, 2, 4

WHERE email LIKE '@gmail.com%'

WHERE email LIKE '%@gmail.com'

WHERE email LIKE '%@gmail.com%'

WHERE email = '@gmail.com'

SELECT id, title FROM articles LIMIT 5;

SELECT id, title FROM articles ORDER BY views ASC LIMIT 5;

SELECT id, title FROM articles ORDER BY views DESC LIMIT 5;

SELECT TOP 5 id, title FROM articles ORDER BY views DESC;

WHERE YEAR(ordered_at) = 2026 AND MONTH(ordered_at) = 5

WHERE ordered_at LIKE '2026-05%'

WHERE ordered_at >= '2026-05-01' AND ordered_at < '2026-06-01'

WHERE DATE_FORMAT(ordered_at, '%Y-%m') = '2026-05'