INSERT INTO (ShortHand)
INSERT INTO (Long Form)
SELECT ALL pokemons
SELECT specific columns
SELECT COLUMNS DISTINCT
SELECT WITH CONDITIONS (WHERE)
SELECT WITH CONDITIONS (OR WHERE)
SELECT WITH CONDITIONS (AND WHERE)
SELECT WITH CONDITIONS (>)
SELECT WITH CONDITIONS (<>)
SELECT WITH CONDITIONS (BETWEEN)
SELECT ORDER BY (ASC/DESC)
SELECT LIMIT
SELECT OFFSET
SELECT LIMIT (without offset)
SELECT SEARCH (LIKE)
SELECT SEARCH(LIKE: Star with W)
SELECT SEARCH(LIKE: End with e)
SELECT SEARCH(LIKE: Contains)
SELECT SEARCH( NOT LIKE: Contains)
SELECT SEARCH(LIKE: Complete)
SELECT SEARCH(IN)
SELECT CHALLENGE
List pokemons type water average speed
List all pokemons total sum all skills
Count all pokemons type water
SELECT (ALIAS: Two Tables)
List all trainers with their pokemons
SELECT (ALIAS: Two Tables with ORDER BY)
List all trainers with their pokemons ordered desc
SELECT (ALIAS: Two Tables with AND OR & ORDER BY)
List all trainers with their pokemons type water or fire
SELECT (ALIAS: Two Tables - COUNT)
List trainer with number of pokemons
SELECT (ALIAS: Three Tables)
List all trainers with their pokemons and gyms
SELECT (INNER JOIN: Three Tables )
List all trainers with their pokemons and gym
SELECT (LEFT JOIN: Three Tables )
List all trainers with their pokemons and gym
SELECT (RIGHT JOIN: Three Tables )
List all trainers with their pokemons and gym
SELECT (UNION: Three Tables )
List all trainers, pokemons and gym in one column
CREATE VIEW
Create a view that contains all trainers with their pokemons and gym
SHOW VIEW
Show a view that contains all trainers with their pokemons and gym
UPDATE
One field
Two or more fields
DELETE
One row
ALL rows
TRANSACTION
Begin a trnsaction, delete somethinf, rollback