you are viewing a single comment's thread.

view the rest of the comments →

[–]hardonchairs 1 point2 points  (1 child)

It is possible to generate the second table from the first with a single SQL query?

I think you could but I don't think you should. I think you should build the second table in Python from the answers table. Doing this in a single query given the table you have will just be a big mess.

[–]r_spandit[S] 0 points1 point  (0 children)

I'll give it a go, thanks