Data engineers who read and review SQL every day, but still run into inherited production queries that are painful to reason about. You've got a 150-line query, an INSERT ... SELECT, a MERGE, or a ...
SELECT * FROM movies WHERE studio IN ("marvel studios" , "Yash raj Films"); SELECT count(*) FROM movies WHERE studio IN ("marvel studios" , "Yash raj Films"); # lets use NULL and NOT NULL , works only ...