Would this help you:

SELECT name, MIN(price) min_pice , MAX(price) max_pice, min(date) min_date, max(date) max_date

from table

group by name

order by name

As said by Bhuvnesh, please go thro the article he referred and post data in a readily-consumable format along with the clear-cut desired output..