Calculated fields in SQL

The SalesAmount is evidently a calculated field, derived from multiplying the Quantity by the Price.

SQL facilitates these computations, integrating the results into the fields listed in the SELECT clause. For instance, the following example demonstrates the equivalent of SalesAmount.