FastPrepProduct Profit Summary
Problems/Product Profit Summary

Product Profit Summary

Jane Street logoJane Street● EasyFULLTIMEOA

Updated Sep 2026

QuestionConstraints

Problem statement

Source note: Seen in two Jane Street trading desk operations reports posted in 2026, both about an online test. A London report lists lookups and profit among the things its first-round spreadsheet test asked for, along with other business and math questions. A New York engineer report also gives profit as its task, worked out from spreadsheet data. Neither report gives the data or how profit was defined.

We built one query from the profit part. Linking the London report's lookups to a cost lookup per product is ours. Matching the New York report, which names only profit, to this task is ours. So are the two tables of products and sales, profit as sales minus cost over every unit sold, units and revenue next to it, a row for every product including unsold ones, the table and column names, the 0.0001 tolerance and all the data. The other business and math questions the London report mentions are not part of our version.

Our version is about 30% the same as the reported question.

A shop keeps two tables. The products table lists each product with its product_name and the unit_cost the shop pays for one unit. The sales table has one row per sale: the product_id, the quantity of units sold and the unit_price each unit was sold for. The same product can sell at different prices.

Return one row for every product in products, with these columns:

  • product_id and product_name
  • units_sold: the total quantity sold.
  • revenue: the sum of quantity * unit_price over its sales.
  • profit: revenue minus cost, where the cost of a sale is quantity * unit_cost. It is negative when the product sold below cost.

A product with no sales gets 0 in all three number columns. Return the rows in any order. A decimal answer is accepted when it is within 0.0001 of the exact value.

Table schema

MySQLPostgreSQLPandas

Use the same input data with any supported language. Open the Schema tab in the editor to see the generated SQL setup or Pandas DataFrames.

products

One row per product.

ColumnTypeNullableDescription
product_idPKIntegerNoUnique product ID.
product_nameTextNoProduct name.
unit_costDecimalNoWhat one unit costs the shop.

sales

One row per sale.

ColumnTypeNullableDescription
sale_idPKIntegerNoUnique sale ID.
product_idIntegerNoProduct sold.
quantityIntegerNoUnits sold.
unit_priceDecimalNoPrice of each unit in this sale.

Expected result

Your query or function must return these columns.

ColumnTypeNullableDescription
product_idIntegerNo—
product_nameTextNo—
units_soldIntegerNo—
revenueDecimalNo—
profitDecimalNo—

Row order: any order is accepted. Numeric tolerance: 0.0001.

Constraints

  • products has between 1 and 100 rows, and product_id values are unique.
  • product_name has 1 to 30 characters: English letters, digits and spaces. Two products may share a name.
  • sales has between 1 and 1000 rows, sale_id values are unique, and every sale's product_id appears in products.
  • 1 <= quantity <= 10000
  • 0 < unit_cost, unit_price <= 1000, with at most 4 digits after the decimal point.

More Jane Street interview questions

  • Cheating CodemakerOA · Seen Mar 2026
  • Bond Haircut by Ratings and MaturityOA · Seen Aug 2024
  • Currency Haircut with FX ForwardsOA · Seen Aug 2024
  • Transform StringOA · Seen Jul 2024
  • Price Deviation AlertsOA · Seen Nov 2023
  • Trade Blotter Summary by TickerOA · Seen Jun 2021
  • Biggest Daily Move and Longest Rising StreakOA · ONSITE INTERVIEW · Seen Apr 2021
  • Transaction Fees by InstrumentOA · Seen Mar 2018
  • Maximum-Scoring Consecutive Tree LevelsPHONE SCREEN · Seen Nov 2026
  • Tree Selection and VisibilityPHONE SCREEN · Seen Nov 2026

Similar questions at other companies

  • Students Scoring Above AverageCapstone Investment Advisors · OA
  • Bond Interest Summary Above 3%Wells Fargo · OAWells Fargo interview questions
  • Employee Promotion OpportunitiesIntuit · OAIntuit interview questions
  • Students and Their SubjectsBirla Pivot · OA
  • Companies with Average Salary Above 40000AT&T · OAAT&T interview questions
  • Build Taxi Driver Performance FeaturesBoston Consulting Group · OABoston Consulting Group interview questions
  • Weekend Appointments for Consular Services ReschedulingMcKinsey & Company · OAMcKinsey & Company interview questions
  • Companies Above a Salary ThresholdVerisk · OA
  • Customer Resource Usage AnalysisIBM · OAIBM interview questions
  • Customers Who Never OrderedAccenture · OAAccenture interview questions

Interview reports that mention this question

  • Jane Street TDOE UK Phone Screen: 15 Experiences (Part 4 of 10)
  • Jane Street TDOE Interviews: 165 Experiences (Part 1 of 10)
  • Jane Street TDOE US Phone Screen: 20 Experiences (Part 6 of 10)

Jane Street interview experiences

  • Jane Street TDO UK and Hong Kong: 22 Experiences (Part 10 of 10)
  • Jane Street TDOE US Final Round: 11 Experiences (Part 5 of 10)
  • Jane Street TDO Phone Math Round: 26 Experiences (Part 9 of 10)
All Jane Street interview questionsSee Jane Street hiring insights