sql-ecology-lesson icon indicating copy to clipboard operation
sql-ecology-lesson copied to clipboard

Add a description table for SQL keywords (checkout)

Open sbhave77 opened this issue 5 years ago • 3 comments

It would be useful to provide a table (in markdown for example) which provides descriptions about how each SQL query works (as a cheat sheet) for the learners. This will decrease cognitive burden due to having to remember all of these keywords and their use cases. Something like this (although the wording could use some work):

SQL Keyword Description
SELECT specifies which columns of the table are being selected
FROM specifies which table is being selected from
WHERE allows for specification of filter conditions
GROUP BY specifies which columns to group the table by for aggregation. Warning: All columns not specified in group by must be aggregated otherwise you will get an error.

sbhave77 avatar Apr 25 '19 17:04 sbhave77