select top 1 price from B order by date desc
select price from b where date=(select max(date) from b)
