Question

Ques2)Create table below. MATCH_DETAILS and Choose appropriate Primary key and constraints
for each attribute.

Table: MATCH_DETAILS
MatchID
MatchDate
FirstTeamID
SecondTeamID
FirstTeamScore
SecondTeamScore

M1
2018-07-17
1
2
90
86

M2
2018-07-18
3
4
45
48

M3
2018-07-19
1
3
78
56

M4
2018-07-19
2
4
56
67

M5
2018-07-20
1
4
32
87

M6
2018-07-21
2
3
67


a) Insert data as shown in table

b) Retrieve the MatchID of all those matches where both the teams have scored > 70.
c) Retrieve the MatchID of all those matches where FirstTeam has scored < 70 but SecondTeam
has scored > 70.
d) Find out the MatchID and date of matches played by Team 1 and won by it.
e) Find out the MatchID of matches played by Team 2 and not won by it.

f) Differentiate between the following commands with example:
i) ALTER and UPDATE
ii)DELETE and DROP​

Answer 1

Answer:

I have no idea for this question

but you follow me