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.