Question

Write SQL commands for statements (i) to (iii): 3

Table : GAMES

GCODE

GAMENAME

NUMBER

PRIZEMONEY

101

KABADDI

2

5000

102 BADMINTON 2 12000

103

Table tennis

4

8000

105

Chess

2

9000

108

Table tennis

4

25000

i)

Display the details of the game “Table tennis”.

ii)

Identify the primary key in the above table . Also give the reason for your choice.

iii)

Display the game name along with its prize money where the prize money is more

than 10000.
it​

Answer 1

Answer:

Wishing you all the best for the new phase of your life. We are sure that you will succeed and make us proud as always!

All the best to you for reaching towards your goal and making your dreams come true. You are always in my good thoughts!

Best wishes for the challenges you are to face, for the roads you have to take and for the decisions you have to make. Good luck!

Best Wishes