Question

write a query to display the items whose quantity sold is less than 10​

Answer 1

Answer:

Assuming that you're talking about mySQL here we go:

_______________________

select * from table

where sold_quantity<10;

_______________________

Explanation:

"select *" will select all the elements from the table,

and the "where" adds a conditions so the code will return all those values of table in column sold_quantity  with values less than 10.