ByteDance
Medium
Data ScientistAds Campaign Creation Log SQL: Submit Count, Weekly Submit Rate, Time on Site
Data Manipulation (SQL/Python)
1
0
October 29, 2026
NULL handling questions test whether you understand three-valued logic and how NULLs affect filters, joins, and aggregates.
Expect COALESCE, NULLIF, IS NULL, and NULL-safe comparisons in realistic scenarios.
Interviewers care about correctness and edge cases with missing data.
Correct treatment of missing data is the main signal.
Explain how NULLs flow through joins, filters, and aggregates.
State assumptions when the data model is ambiguous.