Leetcode Problem 1132. Reported Posts II

1132. Reported Posts II

Leetcode Solutions

Calculating Average Daily Percentage of Removed Spam Posts

Filter the Actions table to get records where extra is 'spam'.
Remove duplicates from the filtered data based on action_date and post_id to ensure each spam report is counted once per day.
Perform a left join with the Removals table on post_id to find out which reported spam posts were removed.
Group the joined data by action_date and calculate two aggregates: the count of removed spam posts and the size of all reported spam posts.
Calculate the daily percentage of removed spam posts by dividing the count of removed spam posts by the total reported spam posts for each day.
Calculate the overall average of these daily percentages to get the final result.
Round the result to two decimal places as required.

erDiagram
    Actions {
        int user_id
        int post_id
        date action_date
        enum action
        varchar extra
    }
    Removals {
        int post_id
        date remove_date
    }
    Actions }|--|| Removals : ""

Computing Average Daily Percentage of Removed Spam Reports Using Aggregation and Conditional Counting

Ask Question

Programming Language

Purpose:

General Question

Debug My Code

image/screenshot of info(optional)

Full Screen

Leetcode Problem 1132. Reported Posts II

Leetcode Solutions

Calculating Average Daily Percentage of Removed Spam Posts

Solution Idea

Query Steps

Code Implementation

Computing Average Daily Percentage of Removed Spam Reports Using Aggregation and Conditional Counting

Ask Question

Suggested Answer