Monday

Intro

Basic intro lecture

Intro to SQLite Manager

Intro to SQL

Quick example of Selecting, Filtering, and Sorting

Wednesday

Aggregation

Joins

Friday

Missing data

Nesting queries

SELECT yr, COUNT(period)
FROM (SELECT yr, period FROM PortalMammals_main GROUP BY yr, period)
GROUP BY yr;