​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:

Special Conditions

Specific provisions or clauses added to a contract or agreement that must be met in addition to the general terms.

Article 3

A section of the U.S. Constitution that establishes the judicial branch of the federal government, outlining the powers and structure of the Supreme Court and other federal courts.

Negotiable Instruments

Financial instruments, such as checks, promissory notes, and bills of exchange, that contain an unconditional promise or order to pay a specified amount of money and are transferable by endorsement.

UCC

All commercial exchanges in the United States are regulated by the comprehensive legal framework known as the Uniform Commercial Code.