Hello, In the lecture, we use the condition below inside the CASE statement: YEAR(dm.to_date) >= e.calendar_year AND YEAR(dm.from_date) <= e.calendar_year But as far as I know, that statement is logically equivalent to: YEAR(dm.from_date) <= e.calendar_year <= YEAR(dm.to_date) which I used in my query when trying to do it by myself. However, my active field return all 1's and no 0's. Does that mean that MySQL take the two logical statements differently? Why is that? Thanks, Carl

It's not that I don't want to use the methods mentioned above. I'm just exploring ways to write clean code, and I thought that if its mathematically logical, then it should also work, but apparently there's some limitations to that.

Follow this topic

Carl Angelo Catchola

Last answered:

18 Nov 2022

Posted on:

25 Sept 2022

Resolved: Question on Logical Operators

in SQL + Tableau / Problem 2: Solution in SQL

3 answers ( 3 marked as helpful)

Martin Ganchev

Instructor

Posted on:

30 Sept 2022

Helpful answer

Asma Ben Cheikh

Posted on:

18 Nov 2022

Helpful answer

Carl Angelo Catchola

Posted on:

18 Nov 2022

Helpful answer

Resolved: Question on Logical Operators

Submit an answer

related questions