Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Proposed changes for 01-sql-basic-queries.md #3

Open
mpfl opened this issue Jun 2, 2016 · 0 comments
Open

Proposed changes for 01-sql-basic-queries.md #3

mpfl opened this issue Jun 2, 2016 · 0 comments

Comments

@mpfl
Copy link
Contributor

mpfl commented Jun 2, 2016

Writing my first query

  • Requires explicit instructions to go to "Execute SQL" in SQLite

Calculated values

  • Suggest expand g into grams and kg into kilograms. Likewise for mg into milligrams for the Challenge underneath.
  • Suggest explaining why we use 1000.0 instead of 1000 for calculating weight in kilograms

Functions

  • Suggest introducing ROUND in a little more detail and how ROUND(weight/1000.0, 2) will take the value of weight/1000.0 and round to two decimal places.

Escaping STRING

  • Suggest adding an explanatory box about why we escape STRING but not other data types. Can use both single quotes (') and double quotes (") for escaping.

Filtering

  • Suggest adding explanatory box about operators i.e. <, <=, >, >=, =, !=
cmacdonell pushed a commit to cmacdonell/library-sql that referenced this issue Jun 3, 2016
CONTRIBUTING: Split development notes into their own file
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant