The query that is used to summarize the data from various tables is called as:

Question

Accepted Answer

The correct option is (4):
The correct term for a query used to summarize data from various tables, particularly by calculating aggregate values and displaying them in a matrix format, is a **Crosstab query**. This query type is a powerful analytical tool, transforming data by rotating the result set's row values into column headings. It allows you to compute and display sums, averages, or counts for data grouped by two dimensions (one for the rows, one for the new columns), which is precisely what is meant by "summarize the data from various tables." The structure of a crosstab is essential for creating concise, readable summary reports and is the most precise answer to describe this specific function.

The incorrect option is (1):
The term **SQL query** is too broad and generic in this context. SQL (Structured Query Language) is the standard language used for *all* operations in a relational database, including retrieving, inserting, and modifying data. While a summarization query *is* written using SQL (often involving aggregate functions and the `GROUP BY` clause), the term 'SQL query' describes the language, not the specific summarization purpose. Crosstab query, conversely, describes the resulting summarized data structure.

The incorrect option is (2):
A **Join query**'s primary purpose is to **combine** rows from two or more tables based on a related column between them. The core function of a join is to link or associate related records across different tables, effectively creating a single, comprehensive dataset. A join, by itself, focuses only on the relationship between tables and the consolidation of their columns; it does not inherently perform the aggregation or summarization of the data itself.

The incorrect option is (3):
A **Selection query** is primarily a data retrieval operation, where the user selects specific columns and filters rows based on criteria using the `WHERE` clause. Its main goal is to retrieve a subset of the raw data. This query type does not, by default, perform the aggregation, calculation, and dimensional restructuring needed to *summarize* the data. It is used for viewing filtered records rather than generating condensed, analytical reports.