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).
Course: Advanced SQL
Lesson: Writing Efficient Queries
Section: 2) Read less data
This section contains two issues in the text: