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 897 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 685 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 765 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 876 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 673 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 595 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 640 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 828 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 1413 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 3735 views Grand Master

Register Now

Login

Lost Password

Category : SQL