SQL Join and Daily Aggregation

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is SQL Join and Daily Aggregation. Start with the requirements and the one table on the right.

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

You need to log in / sign up to run or submit.

Problem

Alpaca's trading operations team needs a daily summary of executions shown in its brokerage activity reporting. Write a PostgreSQL query against the execution records.

Requirements

Include only rows where execution_status is filled.
Group results by the calendar date of execution_time, returning the number of filled executions and total notional.
Sort the output from the earliest day to the latest day.

Schema

trade_executions

Column	Type	Description
execution_idPK	INT	Unique execution identifier
account_id	VARCHAR(20)	Alpaca brokerage account identifier
execution_time	TIMESTAMP	Timestamp when the execution was recorded
execution_status	VARCHAR(20)	Current execution status
notional	DECIMAL(12,2)	Dollar value of the execution

Tablestrade_executions

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results