Question

Using the sports database containing two relations (TEAM, MATCH_DETAILS) and write the Query for the following:

Display the MatchID of all those matches where FirstTeam has scored less than 70 but SecondTeam has scored more than 70.

Answer 1

SELECT MatchID FROM MATCH_DETAILS WHERE FirstTeamScore < 70 AND SecondTeamScore < 70;