O'Reilly logo
  • Ares Ou thinks this is interesting:

sum(ORDER_QTY * PRICE) as TOTAL_REVENUE

From

Cover of Getting Started with SQL

Note

When using aggregation, the result will be one record (the aggregation) but not records even you have selected more than one row from the table, unless you use group to create aggregations.