A retail company needs to analyze its sales data but has identified that some records contain missing values. Write a SQL query to summarize the total sales amount while handling incomplete data appropriately.
amount column.product_id and return only those products with total sales greater than 100.product_name along with the total sales.sales (id, product_id, product_name, amount, sale_date)
| id | product_id | product_name | amount | sale_date |
|---|---|---|---|---|
| 1 | 101 | Widget A | 150 | 2024-01-01 |
| 2 | 102 | Widget B | NULL | 2024-01-02 |
| 3 | 101 | Widget A | 200 | 2024-01-03 |
| 4 | 103 | Widget C | 50 | 2024-01-04 |
| 5 | 102 | Widget B | 100 | 2024-01-05 |
| 6 | 101 | Widget A | NULL | 2024-01-06 |
| 7 | 103 | Widget C | 75 | 2024-01-07 |
| 8 | 104 | Widget D | 30 | 2024-01-08 |
| product_id | product_name | total_sales |
|---|---|---|
| 101 | Widget A | 350 |
| 102 | Widget B | 100 |