Text contradiction - Advanced SQL Course
Nobody has claimed this yet.
Assessment
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Newbie friendliness
- 75/100
- Issue type
- Documentation
- Clarity
- Mostly clear
- Activity status
- Active
- Tech stack
- jupyter-notebook, sql
- Domain
- documentation
Research direction
Open the Advanced SQL course, the Writing Efficient Queries lesson, and section 2, “Read less data”; review the cited text and the less_data_query code cell together. Done means the explanation no longer contradicts the preceding sentence or query, and the intro accurately describes what both queries calculate.
Written by the indexing model from the issue text.
Description
Course: Advanced SQL
Lesson: Writing Efficient Queries
Section: 2) Read less data
This section contains two issues in the text:
- Text Contradiction: The sentence "By using only the columns with the station IDs, we scan less data" contradicts both the preceding sentence (which states IDs are not needed) and the less_data_query code (but it uses both station names).
- Mismatched Intro: The intro sentence states "Both queries below calculate the average duration.", however, the code cell below it calculates the byte size instead of the time (duration).
- Dominant language
- Jupyter Notebook
- Stars
- 515
- Forks
- 274
- Avg merge
- 14d 16h
- Merged PRs (30d)
- 1
Getting set up
This project ships no dev container, Dockerfile or contributing guide, so setting up is up to you: start from its README, and see our first-contribution guide for the general steps.
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
More from Kaggle/learntools
-
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
Kaggle/learntools#278 ·
-
Typo in Intro to Deep Learning exercisePossibly taken A pull request linked to this issue is open or already merged. Open
Difficulty 1/5 Under an hour Newbie friendliness 45/100
Kaggle/learntools#484 · 2 comments ·
-
Difficulty 3/5 1-2 days Newbie friendliness 35/100
Kaggle/learntools#476 · 2 comments ·
-
Difficulty 1/5 Under an hour Newbie friendliness 52/100
Kaggle/learntools#468 ·
-
Difficulty 2/5 1-3 hours Newbie friendliness 45/100
Kaggle/learntools#467 ·
All issues in Kaggle/learntools
Similar issues
-
Difficulty 2/5 1-3 hours Newbie friendliness 85/100
CopilotKit/OpenDots#55 ·
Maintainers usually reply within 1 day
-
Security SecurityBundle
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
symfony/symfony-docs#23173 ·
Maintainers usually reply within 3 days
-
OSCI'26
Difficulty 2/5 1-3 hours Newbie friendliness 68/100
GauravKarakoti/SecureFlow#1215 ·
Maintainers usually reply within 1 day
-
Difficulty 1/5 Under an hour Newbie friendliness 88/100
containers/bubblewrap#813 · 1 reaction ·
Maintainers usually reply within 1 day
-
Difficulty 2/5 1-3 hours Newbie friendliness 62/100
szTheory/exifcleaner#383 ·
Maintainers usually reply within 1 day