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

01-sql-basic-queries: adding basic information on SQL code at the begining

Open MathildeMousset opened this issue 5 years ago • 1 comments

When learning to write my first queries, I was missing a couple of information, which are given in later.

  1. The ";" I would be good to explain what is the role of the comma (the query works without it, why bother?)

  2. Line breaks The learner needs to know whether line breaks are necessary for the code to work. The information is given at the end of the episode, and I suggest to move it here, at the very begining.

It is possible to write a query as a single line, but for readability, we recommend to put each clause on its own line.

  1. Indentation I suggest to mention that indentation is also possible, and can improve code readibility at that point.

MathildeMousset avatar Apr 30 '19 12:04 MathildeMousset