FROM time t, product p, purchases ps
WHERE t.time_key = ps.time_key AND
ps.product_id = p.product_id AND
t.year BETWEEN 2000 and 2003
GROUP BY t.month, p.product_id;
Id Operation Name
__________________________________________________
0 SELECT STATEMENT
1 SORT GROUP BY
2 VIEW
3 UNION-ALL
4 HASH JOIN
5 VIEW
6 SORT UNIQUE
|