Here is the link to my issue. SQL Multiple Tables Section 7 Instruction 3.
Code I’m using is below, please let me know if it’s flawed in some way.
Q3 makes no sense to me in the WHERE statement. The hint says to look at the month column and you’ll see that some are gone now. I did it and I don’t understand why some are missing.
The way it reads to me is this: you have start_month which can be anything between 1 and 12. And you have the month column which can be between 1 and 12 as well. In the FROM and AND statement below, there is no numerical limiter to narrow results down. It reads more like: if start_month = 12 and month = 1, it’s not going to show it in the result because 12 is not less than or equal to 1.
Sorry, it’s hard to explain this clearly. It might be best if someone just explains Q3 in painstaking detail to me I was acing it until this lesson and now I hit a hard wall for two days in a row now.
CROSS JOIN months
WHERE start_month <= month
AND end_month >= month;