The Following SQL Statement Contains Which Type of Subquery? SELECT

question 131

Multiple Choice

The following SQL statement contains which type of subquery? SELECT title, retail, category, cataverage FROM books NATURAL JOIN
(SELECT category, AVG(retail) cataverage FROM books GROUP BY category) ;

• A) correlated
• B) single-row
• C) multiple-row
• D) multiple-column

---

Definitions:

Consumer Goods

Products and services that are purchased by individuals for personal or household use, rather than for manufacturing or reselling.

Progressive-Era Union

Labor unions during the Progressive Era aimed at improving working conditions, increasing wages, and reducing working hours for the labor force in the early 20th century.

Higher Wages

An increase in the amount of money paid to workers per unit of time, often seen as a way to improve living standards and stimulate economic growth.

Gilded Age

A period in the late 19th century known for the transformation of the United States through industrialization, urbanization, and the rise of big business, alongside stark social inequalities.