Intuit·Software Engineer·Technical Phone Screen
- Given a coins table and a transactions table, write a single SQL query that returns each coin's name alongside the summed transaction amount per calendar quarter, the total transaction count, and the total amount. Handle coins that have no transactions.
“The quarterly breakdown part is straightforward if you've seen conditional aggregation before.”