How would you approach Python, R, or SQL data manipulation on a small dataset?
Use the dataset_rows table below as the input. Write a SQL query that standardizes the data, removes unusable rows, and summarizes the cleaned records by category.
categorycategory, clean_row_count, valid_value_count, average_scorecategory is NULL or empty, and ignore rows where score is NULLclean_row_count descending, then category ascending| Column | Type | Description |
|---|---|---|
| row_idPK | INT | Unique row identifier |
| category | VARCHAR(50) | Category label for the record |
| score | NUMERIC(10,2) | Numeric value used for summary |
| source_system | VARCHAR(50) | System that produced the row |
| ingested_at | DATE | Date the row was loaded |