Aggregate Interactions By Hour | Dataford Interview Questions

How would you write a query to aggregate user interactions by hour?

Use the user_interactions table. Count interactions for each non-null timestamp hour and return the results in chronological order.

Output

user_interactions

Column	Type	Description
interaction_idPK	INT	Unique identifier for the interaction
user_id	INT	Identifier of the user who performed the interaction
interaction_timestamp	TIMESTAMP	Timestamp when the interaction occurred
interaction_type	VARCHAR(50)	Type of user interaction

Your question is Aggregate Interactions By Hour. Start with the requirements and the one table 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.

How would you write a query to aggregate user interactions by hour?

Use the user_interactions table. Count interactions for each non-null timestamp hour and return the results in chronological order.

user_interactions

Column	Type	Description
interaction_idPK	INT	Unique identifier for the interaction
user_id	INT	Identifier of the user who performed the interaction
interaction_timestamp	TIMESTAMP	Timestamp when the interaction occurred
interaction_type	VARCHAR(50)	Type of user interaction

Your question is Aggregate Interactions By Hour. Start with the requirements and the one table 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.