Question

Consider the following tables-GAMES and PLAYER and give the output for following SQL
queries(i) to (ii)
Table : GAMES
G_CODE Game_Name Number Prize_Money Schedule_Date
101
Carom Board 2
5000
23-Jan-2004
102
Badminton
2
12000
12-Dec-2003
103
Table Tennis
4
8000
14-Feb-2004
105
Chess
2
9000
01-Jan-2004
108
Lawn Tennis
19-Mar 2004
4
25000
Table:PLAYER
Pcode
Name
Gcode
1
Nabi Ahmad
101
2
Ravi Sharma
108
3
Jatin
101
4
Nazneen
102

(i)SELECT MAX(Schedule_Date), MIN(Schedule_Date) FROM GAMES;
2)SELCT SUM(Prize_Money) FROM GAMES;​

Answer 1

Answer:

hmm

Explanation:

carey minati pubg

total gaming free fire

PewDiePie minecraft

Answer 2

Given :

The two SQL Query Tables :

GAMES Table Schema : G_CODE | Game_Name | Number | Prize_Money | Schedule_Date

PLAYER Table Schema : Pcode | Name | Gcode

To Find :

The result of the given SQL queries run on the given table records

Solution :

1. SELECT MAX(Schedule_Date), MIN(Schedule_Date) FROM GAMES

The MAX and MIN operators in SQL return the maximum and minimum values from all the values of the selected column respectively.

Here, the list of values in the Schedule_Date column is :

23-Jan-2004, 12-Dec-2003, 4-Feb-2004, 01-Jan-2004, 19-Mar 2004

We find Max and Min using the alphabetical order as the date inputted is not in the standard format.

Maximum Date according to alphabetic order : 23-Jan-2004

Minimum Date according to alphabetic order : 01-Jan-2004

Thus, the output result is

MAX(Schedule_Date) - 23-Jan-2004

MIN (Schedule_Date)  - 01-Jan-2004

2. SELECT SUM(Prize_Money) FROM GAMES

The SUM operator in SQL returns the sum of all the values of the selected column.

Here, the list of values in the Prize_Money column is :

5000, 12000, 8000, 9000, 25000

The sum of all values

                    $= 5000 + 12000+8000+9000+25000$

                     $= 59000$

Thus, the output result is SUM(Prize_Money) - 59000.

To learn more about SQL, visit

https://brainly.in/question/17188651

#SPJ6