Question 1

Q3 | Guess the question

Question

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')

in progress 0

SQL 55 years 1 Answer 965 views Grand Master

Question 2

Q4 | Guess the question

Question

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%')

in progress 0

SQL 55 years 1 Answer 732 views Grand Master

Question 3

Q6 | Guess the question

Question

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')

in progress 0

SQL 55 years 1 Answer 811 views Grand Master

Question 4

Q7 | Guess the question

Question

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')

in progress 0

SQL 55 years 1 Answer 935 views Grand Master

Question 5

Q8 | Guess the question

Question

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 ...

in progress 0

SQL 55 years 1 Answer 723 views Grand Master

Question 6

Q9 | Guess the question

Question

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 ...

in progress 0

SQL 55 years 1 Answer 626 views Grand Master

Question 7

Q10 | Guess the question

Question

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 ...

in progress 0

SQL 55 years 1 Answer 673 views Grand Master

Question 8

Offset function real use case?

Question

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

0

SQL 55 years 0 Answers 862 views Newbie

Question 9

Case Study in SQL

Question

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

in progress 2

SQL 55 years 3 Answers 1477 views Grand Master

Question 10

Create a ranking row without using Rank function in SQL

Question

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

in progress 4

SQL 55 years 3 Answers 3806 views Grand Master

Register Now

Login

Lost Password

Category : SQL