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

Fix typo in filter exercise prompt #214

Closed
wants to merge 1 commit into from

Conversation

ixjlyons
Copy link

@ixjlyons ixjlyons commented Mar 16, 2018

The rest of the prompt and the solution use 48, which is the right way to go because WHERE (lat > -42) AND (lat < 42); doesn't match any of the records.

@remram44
Copy link
Contributor

The exercise is in fact correct! 90-42 = 48

Remember that 0 latitude is at the equator, not the pole, so 42 degrees from the pole is latitude 48°.

@ixjlyons
Copy link
Author

Ha! Thanks.

@ixjlyons ixjlyons closed this Mar 16, 2018
rgaiacs added a commit to rgaiacs/swc-sql-novice-survey that referenced this pull request Apr 17, 2018
…securely

Link DOIs to preferred resolver
@remram44 remram44 mentioned this pull request Dec 12, 2018
henrykironde added a commit to henrykironde/sql-novice-survey that referenced this pull request Sep 19, 2019
- Add pictures to explain
- use 42° instread of 48°

This is a result of all the contributions
and discussion from:

@Denubis
Brian Ballsun-Stanton <Denubis@users.noreply.github.com>

@wtgee
Wilfred Tyler Gee <wtylergee@gmail.com>

@remram44
closes swcarpentry#292, swcarpentry#291

ref: swcarpentry#273 swcarpentry#214 and swcarpentry#278.
henrykironde added a commit to henrykironde/sql-novice-survey that referenced this pull request Sep 19, 2019
- Add pictures to explain
- use 42° instread of 48°

This is a result of all the contributions
and discussion from:

@Denubis
Brian Ballsun-Stanton <Denubis@users.noreply.github.com>

@wtgee
Wilfred Tyler Gee <wtylergee@gmail.com>

@remram44
closes swcarpentry#292, swcarpentry#291

ref: swcarpentry#273 swcarpentry#214 and swcarpentry#278.
henrykironde added a commit to henrykironde/sql-novice-survey that referenced this pull request Sep 19, 2019
- Add pictures to explain
- use 42° instead of 48°

From the contributions
and discussions of:
@Denubis
Brian Ballsun-Stanton <Denubis@users.noreply.github.com>
@wtgee
Wilfred Tyler Gee <wtylergee@gmail.com>
@remram44

closes swcarpentry#292, swcarpentry#291

ref: swcarpentry#273 swcarpentry#214 and swcarpentry#278.
henrykironde added a commit to henrykironde/sql-novice-survey that referenced this pull request Sep 19, 2019
- Add pictures to explain
- use 42° instead of 48°

From the contributions
and discussions of:
@Denubis
Brian Ballsun-Stanton <Denubis@users.noreply.github.com>
@wtgee
Wilfred Tyler Gee <wtylergee@gmail.com>
@remram44

closes swcarpentry#292, swcarpentry#291

ref: swcarpentry#273 swcarpentry#214 and swcarpentry#278.
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

Successfully merging this pull request may close these issues.

2 participants