Before anything else, you need to find the rule that allow you to transform this data:
Price Age Name
3000 30 Ram
2000 20 Ram
1000 10 Ram
to this result:
Price Age Name
1000 30 Ram
This site will help you to learn SQL:
SQL Tutorial[
^]
Quote:
Write a Sql query and display output
We do not do your HomeWork.
HomeWork is not set to test your skills at begging other people to do your work, it is set to make you think and to help your teacher to check your understanding of the courses you have taken and also the problems you have at applying them.
Any failure of you will help your teacher spot your weaknesses and set remedial actions.
Any failure of you will help you to learn what works and what don't, it is called 'trial and error' learning.
So, give it a try, reread your lessons and start working. If you are stuck on a specific problem, show your code and explain this exact problem, we might help.