SELECT query with operator mistake returned value 0. Why?

Q&A DQ Courses
, , , ,
#1

Screen Link:
https://app.dataquest.io/m/574/introduction-to-sql/5/naming-results

My Code:

SELECT 2=3+5+7 AS sum_first_prime_numbers;

What I expected to happen:
[1 rows x 1 columns]

sum_first_prime_numbers

17

What actually happened:

[1 rows x 1 columns]

sum_first_prime_numbers

[1 rows x 1 columns]
sum_first_prime_numbers
0

Extremely new to sql, I have made a mistake in the operator, instead of + after 2, typed = sign. I expected an error message will be thrown. To my surprise, result returned as 0. Curious to understand why this result was given and what logic runs behind.

#2

Hey Priya!

What you are evaluating here is the logical expression 2=3+5+7.

Since 2 is not equal to 15, it returns 0 (False). If you had written for example 2=1+1, it would return 1 (True).

Have a great day!