select prod_name,
(
    select sum(quantity)
    from OrderItems o
    where o.prod_id=p.prod_id
) as quant_sold
from Products p;

子查询顺序是先内再外的话，为什么这里的括号里的p可以被识别啊

还是说内外会一起先from?再where?