Google
Medium
Data ScientistAnalyze User Flags and Review Outcomes for Moderation Prioritization
Data Manipulation (SQL/Python)
67
0
July 12, 2025
SQL NULL Handling Interview Questions
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.
42Questions
18Companies
Common SQL NULL handling interview patterns
- Replacing NULLs with defaults using COALESCE
- Filtering missing data with IS NULL / IS NOT NULL
- NULL behavior in LEFT JOINs
- NULL-safe comparisons in conditional logic
- Handling NULLs in aggregates
SQL NULL handling interview questions
Filter and sort
Robinhood
Medium
Data ScientistIdentify Transactions During 'Golden' Membership Period
Data Manipulation (SQL/Python)
46
0
August 4, 2025
Amazon
Medium
Business Intelligence EngineerIdentify Employees with Invalid Department References
Data Manipulation (SQL/Python)
6
0
July 12, 2025
Meta
Medium
Data EngineerSolve library SQL and Python tasks
Data Manipulation (SQL/Python)
0
2
September 6, 2025
Google
Medium
Data ScientistAnalyze video flags and reviews with SQL
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Pinterest
Medium
Data ScientistFind top category by video time spent
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Capital One
Medium
Data ScientistMerge CSVs and build revenue pivot with pandas
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Amazon
Medium
Data ScientistDiagnose MySQL joins and GROUP BY/HAVING errors
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Lyft
Medium
Data ScientistQuery and transform marketplace data in SQL/Python
Data Manipulation (SQL/Python)
0
0
October 13, 2025
ByteDance
Medium
Data ScientistSelect max-discount product per category
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Fetch Rewards
Medium
Data ScientistWrite SQL to verify quarterly sales decline
Data Manipulation (SQL/Python)
0
0
October 13, 2025
SIG (Susquehanna)
Medium
Data ScientistWrite SQL for deliveries analytics
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistCompute CTR overall and by campaign type
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistWrite SQL to analyze group-call concurrency
Data Manipulation (SQL/Python)
0
0
October 13, 2025
DoorDash
Medium
Data ScientistWrite SQL for percent and window changes
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistCompute unread and multi-account user percentages
Data Manipulation (SQL/Python)
0
0
October 13, 2025
CVS Health
Medium
Data ScientistCreate and query an e-commerce schema
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Meta
Medium
Data ScientistWrite SQL for hashtag analytics and joins
Data Manipulation (SQL/Python)
0
0
October 13, 2025
DoorDash
Medium
Data ScientistModel schema and query new-market readiness
Data Manipulation (SQL/Python)
0
0
October 13, 2025
CVS Health
Medium
Data ScientistCompute age-band spend and YoY in Georgia
Data Manipulation (SQL/Python)
0
0
October 13, 2025
Common mistakes with SQL NULL handling
- Using = NULL instead of IS NULL
- Filtering NULLs in WHERE after a LEFT JOIN
- COUNT(column) vs COUNT(*) misunderstandings
- Forgetting NULLs in CASE conditions
- Assuming NULL equals empty string or zero
How NULL handling questions are evaluated in interviews
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.