Semi-structured & modern warehouse SQL
Exercise · SQL & Querying

Predict, then run it

Predict the output

panels(panel, price, colors) = (P1,30,[red,blue]),(P2,18,[green]). Total panel revenue at panel grain — not after exploding the colors:

SELECT SUM(price) AS revenue FROM panels;

Predict the exact output.