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

Interest Income

The revenue earned from deposit accounts or investments through the receipt of interest payments.

Fair Value Option

An accounting strategy that allows companies to measure and report certain financial assets and liabilities at their fair values.

Long-term Notes Receivable

Loans or credit extended to others that are not expected to be repaid within the next twelve months, reported as long-term assets on the balance sheet.

Fair Value

The price that would be received for selling an asset or paid for transferring a liability in an orderly transaction between market participants at the measurement date.