What is the result of the following NULL arithmetic: SELECT 5 + NULL * 2?

Question

SQL Fundamentals — Hard

What is the result of the following NULL arithmetic: SELECT 5 + NULL * 2?

Accepted Answer

When performing arithmetic with NULL in SQL, the result is always NULL. In this case, multiplying NULL by 2 results in NULL, and adding 5 to NULL still gives NULL as the final answer.