Query Execution Plans and Physical Design - Physical Database Design - page 199

Figure 11.1 The query compilation and execution process.

Q3.$C4 AS “SUM_BASE_PRICE”,
Q3.$C3 AS “SUM_DISC_PRICE”,
Q3.$C2 AS “SUM_CHARGE”,
(Q3.$C5 / Q3.$C0) AS “AVG_QTY”,
(Q3.$C4 /Q3.$C0) AS “AVG_PRICE”,
(Q3.$C1 / Q3.$C0) AS “AVG_DISC”,
INTEGER(Q3.$C0) AS “COUNT_ORDER”
FROM
(SELECT SUM(Q2.$C2), SUM(Q2.$C3), SUM(Q2.$C4),