> For the complete documentation index, see [llms.txt](https://851958789.gitbook.io/notes/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://851958789.gitbook.io/notes/1113_reported_posts/slt.md).

# 思路1

主要注意post\_id存在duplicate, COUNT的时候注意去重

```sql
SELECT extra AS report_reason, COUNT(DISTINCT post_id) AS report_count
FROM Actions
WHERE action='report' AND extra IS NOT NULL AND action_date='2019-07-04'
GROUP BY extra;
```