Things tagged with SQL

Creating easy reports with pivot tables

I’ve been working on a project that collects various surveys and stores the data very much like below.

table schema

While this is a data structure is very normalized and provides a flexible base to build various surveys with. What it does not provide is an easy interface for building reports.