Your question is Handling Missing Data in PostgreSQL. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
Missing data is common in reporting and analysis, especially when working with operational exports, OpenText analytics datasets, or partially completed records. If you handle it poorly, your counts, averages, and downstream conclusions can be misleading.
Explain how you would handle missing data in a dataset using PostgreSQL. Your answer should cover how you would detect missing values, decide whether to filter, replace, or preserve them, and how functions such as COALESCE, CASE WHEN, and aggregate functions behave with NULL values.
Keep your answer practical and analyst-focused. The interviewer is looking for a clear explanation of trade-offs, common SQL techniques, and how you would avoid introducing incorrect assumptions while preparing data for analysis or reporting.