SQL Home
Adam Caffrey
06/01/2021
This page aims to validate my proficiency my mySQL. Code will be executed using the
sqldf
library.
Basic SQL
SELECT, FROM and LIMIT
SUM, AVERAGE, COUNT, MIN and MAX
ORDER BY, DISTINCT and WHERE
BETWEEN, IN and aliases
LIKE and NOT NULL
GROUP BY
JOIN
Adanced SQL