SQL

SELECT purpose

Easy Free +10 XP

🔒 Sign in to solve

Filter rows

Easy Free +10 XP

🔒 Sign in to solve

Sort results

Easy Free +10 XP

🔒 Sign in to solve

Distinct

Easy Free +10 XP

🔒 Sign in to solve

Limit rows

Medium Free +15 XP

🔒 Sign in to solve

Insert

Easy Free +10 XP

🔒 Sign in to solve

Update

Easy Free +10 XP

🔒 Sign in to solve

Delete

Easy Free +10 XP

🔒 Sign in to solve

Null check

Medium Free +15 XP

🔒 Sign in to solve

Wildcard

Easy Free +10 XP

🔒 Sign in to solve

Inner join

Easy Free +10 XP

🔒 Sign in to solve

Left join

Medium Free +15 XP

🔒 Sign in to solve

Cross join

Hard Free +20 XP

🔒 Sign in to solve

Self join

Hard Free +20 XP

🔒 Sign in to solve

Join key

Medium Free +15 XP

🔒 Sign in to solve

Count

Easy Free +10 XP

🔒 Sign in to solve

Group by

Medium Free +15 XP

🔒 Sign in to solve

Having vs where

Hard Free +20 XP

🔒 Sign in to solve

Avg ignores null

Hard Free +20 XP

🔒 Sign in to solve

Sum

Easy Free +10 XP

🔒 Sign in to solve

Primary key

Easy Free +10 XP

🔒 Sign in to solve

Foreign key

Medium Free +15 XP

🔒 Sign in to solve

Index purpose

Medium Free +15 XP

🔒 Sign in to solve

Index tradeoff

Hard Free +20 XP

🔒 Sign in to solve

Normalization

Hard Free +20 XP

🔒 Sign in to solve

Denormalization

Hard Free +20 XP

🔒 Sign in to solve

Transaction ACID

Hard Free +20 XP

🔒 Sign in to solve

Rollback

Medium Free +15 XP

🔒 Sign in to solve

Isolation dirty read

Hard Free +20 XP

🔒 Sign in to solve

Subquery

Medium Free +15 XP

🔒 Sign in to solve

View

Medium Free +15 XP

🔒 Sign in to solve

Window function

Hard Free +20 XP

🔒 Sign in to solve

Union

Medium Free +15 XP

🔒 Sign in to solve

Union all

Hard Free +20 XP

🔒 Sign in to solve

Case expression

Medium Free +15 XP

🔒 Sign in to solve

Coalesce

Hard Free +20 XP

🔒 Sign in to solve

Group concat

Hard Free +20 XP

🔒 Sign in to solve

Explain

Hard Free +20 XP

🔒 Sign in to solve

Composite index order

Hard Free +20 XP

🔒 Sign in to solve

N+1 problem

Hard Free +20 XP

🔒 Sign in to solve

Truncate vs delete

Hard Free +20 XP

🔒 Sign in to solve

Any single char

Medium Free +15 XP

🔒 Sign in to solve

Aggregate + non-agg

Hard Free +20 XP

🔒 Sign in to solve

Correlated subquery

Hard Free +20 XP

🔒 Sign in to solve

Primary vs unique

Hard Free +20 XP

🔒 Sign in to solve

Sum a column

Easy Free +10 XP

🔒 Sign in to solve

Count rows

Easy Free +10 XP

🔒 Sign in to solve

Max value

Easy Free +10 XP

🔒 Sign in to solve

Average value

Medium Free +15 XP

🔒 Sign in to solve

Filter greater than

Medium Free +15 XP

🔒 Sign in to solve

Count matching

Medium Free +15 XP

🔒 Sign in to solve

Distinct count

Hard Free +20 XP

🔒 Sign in to solve

Group sum ordered

Hard Free +20 XP

🔒 Sign in to solve

Min value

Easy Free +10 XP

🔒 Sign in to solve

Order desc top

Hard Free +20 XP

🔒 Sign in to solve

DDL vs DML

Medium Free +15 XP

🔒 Sign in to solve

Alter table

Medium Free +15 XP

🔒 Sign in to solve

Drop table

Easy Free +10 XP

🔒 Sign in to solve

Constraint NOT NULL

Easy Free +10 XP

🔒 Sign in to solve

Check constraint

Hard Free +20 XP

🔒 Sign in to solve