Answer:
(a) Correlated.
Explanation:
Correlated subquery :These sub queries reference columns from outer table or uses values from outer query.These sub queries are processed atleast once for every row processed.So because of this reason correlated sub queries can be slow.Since the query in the question also uses value from the outer query so it is a correlated query.
I think it would be B. The average monthly sales for the big toy company because its giving data over history
Heart is attached to the lungs by the pulmonary artery and vein the artery carries deoxygenated blood to the pulmonary circuit (lungs) the lungs have a gas exchange and the deoxygenated blood goes back to the heart via the pulmonary vein.<span />
Answer is 5. Find an online CRC calculator to verify.