# Case Study Solution (B)

+ In the query target table report_interact_detail, the conditions are met: `reward_type_id='04' and report_dt='2021-08-01'` 
```
select count(*) from report_interact_detail where reward_type_id='04' and report_dt='2021-08-01';
+----------+
| count(*) |
+----------+
|      155 |
+----------+
1 row in set (0.00 sec)
select count(*) from report_interact_detail;
+----------+
| count(*) |
+----------+
|  1550039 |
+----------+
1 row in set (0.00 sec)
```

------------------------------------------------------------
[no notes]