Company SQL Question

Post Count Per User

Practice this Meta style SQL interview question with live execution and instant feedback.

Problem Statement

Show the count of posts created by each user. Display username, user's full name, and total post count. Only include users who have created at least 1 post.

Relevant Tables

usersposts

SQL Concepts Used in This Question

Strengthen your understanding with these targeted learning topics:

Running Totals & Moving AveragesWindow Functions
Conditional Aggregation with CASE & FILTERAggregate Functions & Grouping
ROW_NUMBER, RANK, DENSE_RANKWindow Functions