At companies like BrightCart, demographic fields such as age group, gender, and region are often used in reporting and segmentation. If 30% of critical demographic data is missing, analysts need a practical SQL-based approach that preserves data quality without introducing misleading assumptions.
Explain how you would handle a dataset where 30% of the critical demographic data is missing. In your answer, discuss:
Unknown categoryCASE WHEN, COALESCE, and basic aggregations can help with reportingThe interviewer expects a practical, SQL-oriented explanation rather than advanced statistical imputation. Focus on simple, defensible approaches that are appropriate for reporting and exploratory analysis in PostgreSQL.