| 難度 | 題目 | 答案 | 使用關鍵字 |
|---|---|---|---|
| 6 kyu | SQL Basics: Simple IN | link | IN |
| 6 kyu | Calculating Batting Average | link | CAST、ROUND |
| 8 kyu | Grasshopper - Check for factor | link | MOD |
| 8 kyu | SQL Basics: Simple MIN / MAX | link | MIN、MAX |
| 8 kyu | On the Canadian Border (SQL for Beginners #2) | link | WHERE |
| 8 kyu | Keep Hydrated! | link | FLOOR |
| 7 kyu | Easy SQL: Cube Root and Natural Log | link | cbrt、LN |
| 8 kyu | Easy SQL: Convert to Hexadecimal | link | TO_HEX |
| 7 kyu | Easy SQL: Absolute Value and Log to Base | link | ABS、LOG |
| 8 kyu | Returning Strings | link | FORMAT、CONCAT |
| 8 kyu | Easy SQL - Ordering | link | ORDER BY |
| 7 kyu | SQL Basics: Raise to the Power | link | POWER |
| 8 kyu | Even or Odd | link | CASE |
| 8 kyu | Is n divisible by x and y? | link | AND |
| 8 kyu | Grasshopper - Messi goals function | link | |
| 8 kyu | Register for the Party (SQL for Beginners #3) | link | INSERT INTO |
| 7 kyu | Maximum Multiple | link | |
| 8 kyu | SQL Basics: Simple SUM | link | SUM |
| 8 kyu | SQL Grasshopper: Select Columns | link | SELECT |
| 7 kyu | SQL Basics - Position | link | position |
| 8 kyu | SQL Basics: Simple DISTINCT | link | DISTINCT |
| 6 kyu | SQL Basics: Simple EXISTS | link | EXISTS |
| 6 kyu | SQL Basics - Monsters using CASE | link | JOIN、CASE |
| 7 kyu | SQL Basics: Simple JOIN with COUNT | link | JOIN |
| 6 kyu | SQL Basics: Simple UNION ALL | link | UNION ALL |
| 7 kyu | BASICS: Length based SELECT with LIKE | link | LIKE |
| 7 kyu | Easy SQL: ASCII Converter | link | ASCII、LEFT |
| 7 kyu | SQL with Harry Potter: Sorting Hat Comparators | link | ORDER BY |
| 7 kyu | SQL Basics: Simple JOIN | link | JOIN |
| 7 kyu | SQL with Pokemon: Damage Multipliers | link | JOIN、ORDER BY |
| 7 kyu | SQL Basics: Simple GROUP BY | link | GROUP BY |
| 7 kyu | SQL Basics - Trimming the Field | link | split_part |
| 7 kyu | Sum of odd numbers | link | POWER |
| 難度 | 題目 | 答案 | 使用的函數 |
|---|---|---|---|
| 4 kyu | Dealing With Messy Data | link | GROUP BY、pg_trgm、gin 操作 |
| 4 kyu | Bezos Gets Eccentric with DVD Rentals: Prime Subscriptions for Prime Rentals with Even Digits | [link](/4kyu/Bezos Gets Eccentric with DVD Rentals-Prime Subscriptions for Prime Rentals with Even Digits-SQL.md) | GROUP BY、regexp_split_to_table、generate_series |
| 難度 | 題目 | 答案 | 使用關鍵字 |
|---|---|---|---|
| 6 kyu | SQL: Regex AlphaNumeric Split | link | |
| 7 kyu | SQL with LOTR: Elven Wildcards | link | |
| 8 kyu | Easy SQL: LowerCase | link | LOWER |
| 7 kyu | SQL: Concatenating Columns | link | CONCAT |
| 7 kyu | SQL Basics - Trimming the Field | link | split_part |
| 7 kyu | SQL: Right and Left | link | LEFT、RIGHT、substring |
| 7 kyu | SQL: Padding Encryption | link | REPEAT、CONCAT |
| 難度 | 題目 | 答案 | 使用的函數 |
|---|---|---|---|
| 7 kyu | SQL Basics: Up and Down | link | |
| 6 kyu | SQL Basics: Simple HAVING | link | |
| 7 kyu | SQL: Disorder | link | RANDOM |
| 5 kyu | SQL Basics: Group By Day | link | group by |
| 7 kyu | GROCERY STORE: Logistic Optimisation | link | GROUP BY、ORDER BY、COUNT |
| 6 kyu | SQL Bug Fixing: Fix the JOIN | link | JOIN、CAST、GROUP BY、ORDER BY |
| 6 kyu | SQL Basics: Simple table totaling. | link | RANK、COALESCE、GROUP BY、ORDER BY、SUM、COUNT |
| 5 kyu | SQL Statistics: MIN, MEDIAN, MAX | link | MAX、MIN、PERCENTILE_CONT |
| 難度 | 題目 | 答案 | 使用的函數 |
|---|---|---|---|
| 6 kyu | SQL Basics: Simple FULL TEXT SEARCH | link | to_tsvector、to_tsquery |
| 難度 | 題目 | 答案 | 使用的函數 |
|---|---|---|---|
| 7 kyu | First and last IP in a network | link | network、broadcast |
| 5 kyu | Count IP Addresses | link | inet |
| 難度 | 題目 | 答案 | 使用的函數 |
|---|---|---|---|
| 5 kyu | Using Window Functions To Get Top N per Group | link | RANK、JOIN、subquery |
| 難度 | 題目 | 答案 | 使用的函數 |
|---|---|---|---|
| 5 kyu | SQL Basics: Simple PIVOTING data | link | CROSSTAB |
| 6 kyu | SQL Basics: Simple PIVOTING data WITHOUT CROSSTAB | link |
| 難度 | 題目 | 答案 | 使用的函數 |
|---|---|---|---|
| 5 kyu | SQL Basics: Simple Hierarchical structure | link | RECURSIVE |
| 難度 | 題目 | 答案 | 使用的函數 |
|---|---|---|---|
| 6 kyu | SQL Basics: Simple NULL handling | link | COALESCE、NULLIF |
| 難度 | 題目 | 答案 | 使用的函數 |
|---|---|---|---|
| 7 kyu | SQL Basics: Create a FUNCTION | link | |
| 6 kyu | SQL Basics: Create a FUNCTION (DATES) | link | age、extract |
| 難度 | 題目 | 答案 | 使用的函數 |
|---|---|---|---|
| 6 kyu | Present JSON data the SQL way | link | EXTRACT、AGE、JSON 操作 |
| 難度 | 題目 | 答案 | 使用的函數 |
|---|---|---|---|
| 5 kyu | SQL Basics: Simple VIEW | link | VIEW、GROUP BY |
| 難度 | 題目 | 答案 | 使用的函數 |
|---|---|---|---|
| 6 kyu | SQL Basics: Simple WITH | link | WITH、IN |
| 難度 | 題目 | 答案 | 使用的函數 |
|---|---|---|---|
| 6 kyu | SQL Basics: Top 10 customers by total payments amount | link | LEFT JOIN、GROUP BY、SUM、COUNT、LIMIT |
| 6 kyu | SQL Basics: Simple JOIN and RANK | link | JOIN、GROUP BY、RANK、COUNT |
| 7 kyu | SQL with Pokemon: Damage Multipliers | link | JOIN、ORDER BY |
| 6 kyu | SQL Basics - Monsters using CASE | link | JOIN、CASE |