You have a SQL query that combines customer data and order data. The query includes calculated columns. You need to create a database object that would allow other users to rerun the same SOL query. W

An index is a performance optimization object used to speed up data retrieval, but it does not store or encapsulate a SQL query that returns data.

A view is a virtual table that encapsulates a SQL query, including joins and calculated columns; users can then query the view directly, which re-executes the underlying SQL query to present the result set.

A scalar function returns a single value and is used for specific calculations, not for encapsulating and rerunning a complete query that returns a result set.

A table is used to store raw data; it does not define or encapsulate a pre-defined query with combined data and calculated columns.