​The Following SQL Statement Contains Which Type of Subquery

question 34

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) ​single-row
• B) ​multiple-row
• C) ​correlated
• D) ​uncorrelated

---

Definitions:

Cancer

A broad group of diseases characterized by the uncontrolled growth and spread of abnormal cells.

Homicide

The act of one human killing another, which can include murder and manslaughter.

Autopsy

An autopsy conducted to determine the reason for demise or the severity of illness.

Genetic Disorder

A disease or condition caused by an abnormality in an individual's DNA, varying from minor to severe in its effects.