Practice · 1 of 3

SELECT Filter Simulator

CHALLENGE

Difficulty: intermediate+25 XP

Write selectRows(rows, spec) — rows is an array of objects; spec is { where: { col: value }?, orderBy?: [col, "asc"|"desc"], limit?, offset? }. Apply WHERE (all pairs must equal; a spec value of null matches rows where the column IS null), ORDER BY (stable), then OFFSET, then LIMIT. Return the resulting array.

Press Submit to check your solution.

Back to lesson: Practice: SQL Mechanics — Practice