# 解决方案（B）

+ 查询目标表 report_interact_detail 中，满足条件: `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]