answer only gives headers?

[bossy]

Select inv_qoh, inv_size, color
from inventory
where inv_qoh > 0
and inv_size in ('m', 'l')
and color in ('royal', 'bright pink', 'spruce');

[Frinavale]

Could you please elaborate on the problem that you are facing?
A SQL statement is not a question and we cannot help you any further without some description of the problem that you are having. Please elaborate on your application, what it's supposed to do, what problems your having and post any error messages that you're getting.

-Frinny

[bossy]

thank you but I have solved problem; needed more ()