What is the highest dollar price among the furniture?
select max(price_in_dollar) from furniture_manufacte
Show manufacture information for items with a lower price than this.
select * from furniture_manufacte where price_in_dollar < (select max(price_in_dollar) from furniture_manufacte)
Show only their furniture_id numbers.
select furniture_id from furniture_manufacte where price_in_dollar < (select max(price_in_dollar) from furniture_manufacte)
What are the names of these items?
select t1.name from furniture as t1 join furniture_manufacte as t2 on t1.furniture_id = t2.furniture_id where t2.price_in_dollar < (select max(price_in_dollar) from furniture_manufacte)