LibraryCarpentry / lc-sql

Library Carpentry: SQL
https://librarycarpentry.org/lc-sql/
Other
12 stars 37 forks source link

Change Challenge exercise related to FIltering #114

Closed emcaulay closed 3 years ago

emcaulay commented 3 years ago

I changed the "has more than 4 citations" to "has more than 8 citations" because the dataset only has articles with "computer" that have 8 and 9 citations. if we edit this to have the citation count be greater than 8, then there will be a reason to add the the second filter. (The dataset returns 17 rows for the first condition (Subjects LIKE '%computer%'), and 11 rows when you add the second condition (Citation_Count > 8)

Please delete this line and the text below before submitting your contribution.


Thanks for contributing! If this contribution is for instructor training, please send an email to checkout@carpentries.org with a link to this contribution so we can record your progress. You’ve completed your contribution step for instructor checkout just by submitting this contribution.

Please keep in mind that lesson maintainers are volunteers and it may be some time before they can respond to your contribution. Although not all contributions can be incorporated into the lesson materials, we appreciate your time and effort to improve the curriculum. If you have any questions about the lesson maintenance process or would like to volunteer your time as a contribution reviewer, please contact The Carpentries Team at team@carpentries.org.


libcce commented 3 years ago

This is great! Thanks @emcaulay!