| Field | Expression | Displays |
|---|---|---|
| UnitPrice | (SELECT [UnitPrice] FROM [Products] WHERE [ProductName] = "Aniseed Syrup") | Products whose price is the same as the price of Aniseed Syrup. |
| UnitPrice | >(SELECT AVG([UnitPrice]) FROM [Products]) | Products that have a unit price above the average. |
| Salary | > ALL (SELECT [Salary] FROM [Employees] WHERE ([Title] LIKE "*Manager*") OR ([Title] LIKE "*Vice President*")) | Salary of every sales representative whose salary is higher than that of all employees with "Manager" or "Vice President" in their titles. |
| OrderTotal: [Unit Price]* [Quantity] |
> ALL (SELECT AVG([UnitPrice] * [Quantity]) FROM [Order Details]) | Orders with totals that are higher than the average order value. |