一般

難度	題目	答案	使用關鍵字
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

Text 搜尋

難度	題目	答案	使用的函數
6 kyu	SQL Basics: Simple FULL TEXT SEARCH	link	to_tsvector、to_tsquery

Network Address 函數

難度	題目	答案	使用的函數
7 kyu	First and last IP in a network	link	network、broadcast
5 kyu	Count IP Addresses	link	inet

Window function

難度	題目	答案	使用的函數
5 kyu	Using Window Functions To Get Top N per Group	link	RANK、JOIN、subquery

PIVOTING data

難度	題目	答案	使用的函數
5 kyu	SQL Basics: Simple PIVOTING data	link	CROSSTAB
6 kyu	SQL Basics: Simple PIVOTING data WITHOUT CROSSTAB	link

CTE

難度	題目	答案	使用的函數
5 kyu	SQL Basics: Simple Hierarchical structure	link	RECURSIVE

Null handler

難度	題目	答案	使用的函數
6 kyu	SQL Basics: Simple NULL handling	link	COALESCE、NULLIF

Create Function

難度	題目	答案	使用的函數
7 kyu	SQL Basics: Create a FUNCTION	link
6 kyu	SQL Basics: Create a FUNCTION (DATES)	link	age、extract

JSON

難度	題目	答案	使用的函數
6 kyu	Present JSON data the SQL way	link	EXTRACT、AGE、JSON 操作

VIEW

難度	題目	答案	使用的函數
5 kyu	SQL Basics: Simple VIEW	link	VIEW、GROUP BY

WITH

難度	題目	答案	使用的函數
6 kyu	SQL Basics: Simple WITH	link	WITH、IN

JOIN

難度	題目	答案	使用的函數
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