Your question is Flag Invalid Dashboard Revenue Rows. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
You are given a single table that feeds an NVIDIA business dashboard. Write a PostgreSQL query that returns one row per metric_date showing how many records failed basic data quality checks. Treat a row as invalid if region is NULL or empty, product_line is NULL or empty, revenue_usd is NULL or negative, or units_sold is NULL or negative. Return the date and the count of invalid rows, ordered by date.
| Column | Type | Description |
|---|---|---|
| record_idPK | INT | Unique row identifier |
| metric_date | DATE | Reporting date used in the dashboard |
| region | VARCHAR(50) | Sales region |
| product_line | VARCHAR(50) | NVIDIA product line |
| revenue_usd | DECIMAL(12,2) | Reported revenue in USD |
| units_sold | INT | Number of units sold |