search

data-lessons / library-sql-DEPRECATED

SQLite lesson for librarians NOW MOVED > https://github.com/LibraryCarpentry/lc-sql
https://github.com/LibraryCarpentry/lc-sql
Other
2 stars 16 forks source link

Moved confusing challenge in lesson 3 #43

Closed mttrb closed 7 years ago

mttrb commented 7 years ago

The first challenge in lesson 3:

Write a query that returns: total, average, the min and max number of citations for each journal. Can you modify it so that it outputs only journals with more than 5 citations in average?

requires knowledge of GROUP BY, which isn't introduced until the next paragraph, and HAVING which isn't introduced until the next section.

I have moved this challenge into the HAVING section and added a new, more relevant challenge in its place.

mkuzak commented 7 years ago

Looks good, thank you. I'll merge it.