The Following SQL Statement Contains Which Type of Subquery

question 57

Multiple Choice

The following SQL statement contains which type of subquery?
SELECT title,retail,category FROM books
WHERE retail IN (SELECT MAX(retail) FROM books
GROUP BY category) ;

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

---

Definitions:

Fetal Heart Tones

The sounds or heart rate of a fetus as heard through devices like a Doppler during pregnancy check-ups, important for assessing fetal well-being.

Beats Per Minute

A unit of measure used to quantify the tempo of music, the frequency of heartbeats, or other periodic activity within a minute.

Uterine Souffle

A whooshing sound heard through auscultation over the pregnant uterus, caused by blood flowing through the uterine arteries.

Nägele Rule

A standard way of estimating the due date of a pregnancy by adding one year, subtracting three months, and adding seven days to the first day of a woman's last menstrual period.