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:

Issuer

An entity that issues and is responsible for the financial instruments like stocks or bonds.

Tombstone Ad

An advertisement, typically in the print media, announcing a public offering of securities, with minimal detail.

Preliminary Prospectus

An initial document provided by a securities issuer that describes the company and the investment being offered, prior to finalization.

Free-Writing Prospectus

A written communication used during a securities offering to provide potential investors with additional information not contained within the formal prospectus.