SQL

All you have to do is to go through the code and comment the question for which the following is an answer of   SELECT player, teamid, mdate FROM game JOIN goal ON (id=matchid AND teamid='GER')

All you have to do is to go through the code and comment the question for which the following is an answer of SELECT team1, team2, player FROM game JOIN goal ON (id=matchid AND player LIKE 'Mario%')

All you have to do is to go through the code and comment the question for which the following is an answer of SELECT mdate, teamname FROM game JOIN eteam ON (team1=eteam.id AND coach LIKE '%Santos')

All you have to do is to go through the code and comment the question for which the following is an answer of SELECT player FROM goal JOIN game ON (id=matchid AND stadium = 'National Stadium, Warsaw')

All you have to do is to go through the code and comment the question for which the following is an answer of SELECT id, mdate, COUNT(player) FROM game JOIN goal ON (id=matchid AND (team1 = 'GER' OR team2 = 'GER') AND teamid='GER') GROUP ...

All you have to do is to go through the code and comment the question for which the following is an answer of SELECT mdate, team1, SUM(CASE WHEN teamid = team1 THEN 1 ELSE 0 END) AS score1, team2, SUM(CASE WHEN teamid = team2 THEN ...

All you have to do is to go through the code and comment the question for which the following is an answer of SELECT mdate, team1, SUM(CASE WHEN teamid = team1 THEN 1 ELSE 0 END) AS score1, team2, SUM(CASE WHEN teamid = team2 THEN ...

What's the actual practical use of OFFSET? Do suggest a few use cases. ( I do know what it does )

You have a table with the following 3 columns customer_id, order_id, order_date 123.                   987.            2/9/2020 123                    1234      ...

You have to create one more column in predefined table with Name, Id,Department, and Salary. Now you have to create new column with Rank in it partition by Department