The times listed for the following episode are 15 and 10 minutes for teaching and exercise. [sql-ecology-lesson](https://github.com/datacarpentry/sql-ecology-lesson)/[_episodes](https://github.com/datacarpentry/sql-ecology-lesson/tree/gh-pages/_episodes)/03-sql-joins.md My guess is closer to 1-1.5 hours but I have yet to teach this