What is the average market rate for furniture?
select avg(market_rate) from furniture
Show each furniture id number and its corresponding market_rate.
select furniture_id, market_rate from furniture
Which one has the lowest market_rate?
select furniture_id, market_rate from furniture order by market_rate limit 1
Which one has the highest?
select furniture_id, market_rate from furniture order by market_rate desc limit 1
Also show its name.
select name, furniture_id from furniture order by market_rate desc limit 1