Practice SQL Question | Real Coding Interviews | Hack2hire

NewThe Learning module is now liveSee what's new

Question Bank Learning

Pricing Blog Forum

Quick Summary

Link order quantities with product prices to calculate individual transaction revenues.
Aggregate the computed revenues by product line to determine category totals.
Sort the final output by total revenue in descending order.

What This Tests

Relational joins between parent and child tables
Deriving new metrics before grouping
Using aggregate functions with group clauses
Ordering results by calculated fields

Common Patterns

Inner Join

Aggregation

Sort

Accepted

7/7

Acceptance Rate100.0%

Test Cases

Input

-

Output

-

Expected

-