Content by Specific Users

A easy SQL interview practice problem on DataDriven. Write and execute real sql code with instant grading.

Domain

SQL

Difficulty

easy

Seniority

L3

Problem

The community team is auditing a small group of creators. Pull every piece of content authored by users 'alice', 'aaron42', and 'amelia'. Show the content ID, title, content type, and creator ID, sorted by content ID.

Summary

Two creators. What did they publish?

Practice This Problem

Solve this SQL problem with real code execution. DataDriven runs your SQL queries against a real database and grades it automatically.