​The Following SQL Statement Contains What Type of Subqueries

question 74

Multiple Choice

​The following SQL statement contains what type of subqueries?
SELECT isbn,title FROM books WHERE pubid =
(SELECT pubid FROM books WHERE title = 'SHORTEST POEMS')
AND retail-cost >
(SELECT AVG(retail-cost) FROM books) ;

• A) ​single-row
• B) ​multiple-row
• C) ​multiple-column
• D) ​inline view

---

Definitions:

Central-City Areas

Regions located in the core of metropolitan areas, typically characterized by high population density and significant commercial, governmental, or cultural functions.

Upper-Class Individuals

People belonging to the highest socioeconomic group, typically characterized by wealth, power, and prestigious occupations.

Renovating

The process of renewing, restoring, or improving a building or structure to a good state of repair.

Suburbs

Residential areas on the outskirts of a city or large town, often characterized by lower population density than urban centers but more densely populated than rural areas. These communities are typically connected to the city by infrastructure but offer a more tranquil and spacious living environment.