Aggregate and Calculate - Introduce COUNT before challenge and remove alias

LibraryCarpentry / lc-sql

Library Carpentry: SQL

https://librarycarpentry.org/lc-sql/

Other

12 stars 37 forks source link

Closed JordanPedersen closed 4 years ago

JordanPedersen commented 4 years ago

First challenge requires the use of COUNT and an alias (which we could just get rid of), but we haven't introduced either concept to our learners yet. https://librarycarpentry.org/lc-sql/04-aggregating-calculating/index.html

JordanPedersen commented 4 years ago

Also explain more clearly in the lesson when to use COUNT(*) vs. COUNT(column_name).

librarianlise commented 4 years ago

COUNT actually is introduced early in this lesson but in a bit of an oblique way. So I'll make it more obvious.

librarianlise commented 4 years ago

done! i award myself this first place medal emoji:🥇