HF RL Explorer

Task: Pivot a SQLite Table from Long Format to Wide Format

Task: Pivot a SQLite Table from Long Format to Wide Format: a task in Terminal-Lego-15k (Harbor dataset). Write a SQL solution that pivots (transforms) student marks data stored in long/narrow format into wide format in SQLite. Since SQLite does not have a built-in PIVOT function, you must…

The task

Write a SQL solution that pivots (transforms) student marks data stored in long/narrow format into wide format in SQLite. Since SQLite does not have a built-in `PIVOT` function, you must accomplish this using standard SQL techniques.

Part of PrimeIntellect/Terminal-Lego-15k.