SQL Questions From Given Schema | Dataford Interview Questions

How would you answer SQL questions based on a schema provided to you?

Using the supplied schema, write a PostgreSQL query that summarizes January 2025 download activity for every user. Include only files created during January and downloads recorded during the same month.

Output

One row per user, including users with no qualifying files or downloads.
Return display_name, files_with_downloads, and total_downloads.
Sort alphabetically by display_name.

Schema

users

Column	Type	Description
user_idPK	INT	Unique user identifier
display_name	VARCHAR(100)	User display name

files

Column	Type	Description
file_idPK	INT	Unique file identifier
owner_id	INT	User who owns the file
file_name	VARCHAR(255)	File name
created_at	TIMESTAMP	File creation timestamp

file_events

Column	Type	Description
event_idPK	INT	Unique file event identifier
file_id	INT	File associated with the event
event_type	VARCHAR(30)	Event type, such as download or view
occurred_at	TIMESTAMP	Timestamp when the event occurred

Your question is SQL Questions From Given Schema. Start with the requirements and the three tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem