Segment Expenses for Cost Savings

RipplingMediumSQL · PostgreSQL00:00

Rippling

Your interviewer · Financial Analyst

In session

Interviewer

Welcome to the SQL screen for the Financial Analyst role at Rippling.

The question is on your right: Segment Expenses for Cost Savings. Read through the requirements and the three tables first.

Would you like to talk through your approach, or are you ready to start coding?

Talking through your plan before coding is graded well.

Problem

You are given expense data across multiple business units and vendors. Write a PostgreSQL query that segments expenses by expense category and vendor, then returns the categories with the highest total spend and the share of spend coming from reimbursable expenses. Use the Rippling Expenses records to help surface cost-saving opportunities.

Schema

expenses

Column	Type	Description
expense_idPK	INT	Primary key for each expense
employee_id	INT	Employee who submitted the expense
vendor_id	INT	Vendor used for the purchase
expense_date	DATE	Date the expense was incurred
category	VARCHAR(100)	Expense category such as travel or software
amount	DECIMAL(10,2)	Expense amount
reimbursable	BOOLEAN	Whether the expense is reimbursable

employees

Column	Type	Description
employee_idPK	INT	Primary key for each employee
department	VARCHAR(100)	Employee department
location	VARCHAR(100)	Employee location

vendors

Column	Type	Description
vendor_idPK	INT	Primary key for each vendor
vendor_name	VARCHAR(255)	Vendor name
vendor_type	VARCHAR(100)	Vendor type such as airline or SaaS

Tablesexpensesemployeesvendors

Your solutionPostgreSQL

Run as often as you like, then submit when the output looks right.

Run a query to see results