sql-ecology-lesson
sql-ecology-lesson copied to clipboard
datacarpentry
Improve description of statements/clauses (checkout)
It would be helpful to add a quick description of some of the statements used. Mainly the select statement since I know when I first started I had concerns on if I was changing the underlying data or not. Also the group by, it would be useful to call out that the group by identifier must exist in the select statement.
Description: SELECT statement can access data in a database and returned specified columns, but it cannot manipulate the data where it lives in the database. However, you can manipulate the data returned to you in your SELECT statement, but it won't save to the database.
Description: GROUP BY selection must exist in the select statement.
I second this comment. I think it would be helpful to explicitly say what SELECT is doing and ease some of the fear around changing the underlying data set.
On a similar not, I think it is necessary to point out syntax structure, like what clause is and what the semicolon does.
Also might be addressed by #262 (reference table) and #266 (semi-colon and how queries are structured)
