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:

Molecular Genetics

Molecular genetics is the field of biology and genetics that studies the structure and function of genes at a molecular level.

Plasticity

The brain's capability to change and adapt in structure or function in response to learning or experiences.

Neurogenesis

The process of generating new neurons in the brain, which occurs in certain brain regions throughout life.

Somatosensory Cortex

A region of the cerebral cortex involved in processing sensory information from the body, including touch, temperature, and pain.