This page aims to validate my proficiency my mySQL. Code will be executed using the sqldf library.

Basic SQL

  1. SELECT, FROM and LIMIT
  2. SUM, AVERAGE, COUNT, MIN and MAX
  3. ORDER BY, DISTINCT and WHERE
  4. BETWEEN, IN and aliases
  5. LIKE and NOT NULL
  6. GROUP BY
  7. JOIN

Adanced SQL