How to Use CASE Statements Inside Aggregate Functions in SQL

 Problem

From the table below, I want to calculate the number of published and unpublished posts for each user.

Solution















Comments