Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started
Monthly Ramp Card Spend Summary
00:00
5 left

Monthly Ramp Card Spend Summary

EasySQL · PostgreSQL

Problem

Write a PostgreSQL query on ramp_card_transactions that returns total approved spend by month for calendar year 2024. Show the month as YYYY-MM and sort the output by total spend descending.

Schema

ramp_card_transactions
ColumnTypeDescription
transaction_idINTUnique transaction ID
employee_nameVARCHAR(100)Employee who made the purchase
merchant_nameVARCHAR(100)Merchant on the card transaction
transaction_dateDATEDate of the transaction
amountDECIMAL(10,2)Transaction amount in USD
statusVARCHAR(20)Transaction status
Tablesramp_card_transactions
Interviewer

Your question is Monthly Ramp Card Spend Summary. 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.

You need to log in / sign up to run or submit.
CodePostgreSQL
You need to log in / sign up to run or submit.Ln 1
Run your query to see results here.