SQLeasyJoins~12m

A regional bank wants to analyze account activity by branch location

Problem

A regional bank wants to analyze account activity by branch location. Write a query to find all branches along with their total transaction volume (sum of transaction amounts) for the month of January 2024. Include branches that had no transactions during this period, showing them with a transaction volume of 0. Sort results by branch name alphabetically.

Examples

Example 1

Example 2

Constraints

›Return branch_name and total_volume columns
›Include branches with no January 2024 transactions as 0
›Sort by branch name alphabetically
›Only consider transactions from January 2024

Reference solution

Reference solution available after you attempt the question.

Ready to solve it?

Start a session on Mockbit #43. Write your SQL, run it against real data, and get graded on correctness, efficiency, query structure, and business understanding.