Handling Large Datasets

MediumSQL · PostgreSQL

Problem

How do you handle large datasets?

Using a single PostgreSQL table, write a query that produces a compact summary of processed records. Return the three categories with the most processed records, along with their record counts and total amounts.

Output

One row per category, limited to the top three categories
Columns: category, record_count, and total_amount
Sort by record_count descending, then category ascending to break ties

Schema

records

Column	Type	Description
record_idPK	INT	Unique record identifier
category	VARCHAR(100)	Category assigned to the record
status	VARCHAR(30)	Processing status of the record
amount	DECIMAL(12,2)	Amount associated with the record

Tablesrecords

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.