What is the furniture id number of the most expensive furniture?
select furniture_id from furniture_manufacte order by price_in_dollar desc 1
How about the manufacturer number?
select manufacturer_id from furniture_manufacte order by price_in_dollar desc 1
What is the name of the manufacturer?
select t1.manufacturer_id from manufacturer as t1 join furniture_manufacte as t2 on t1.manufacturer_id = t2.manufacturer_id order by t2.price_in_dollar desc limit 1
Also show how many shops they have.
select t1.manufacturer_id, t1.num_of_shops from manufacturer as t1 join furniture_manufacte as t2 on t1.manufacturer_id = t2.manufacturer_id order by t2.price_in_dollar desc limit 1