Question

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 TheDataMonk 55 years 1 Answer 736 views Grand Master 0

About TheDataMonkGrand Master

I am the Co-Founder of The Data Monk. I have a total of 6+ years of analytics experience 3+ years at Mu Sigma 2 years at OYO 1 year and counting at The Data Monk I am an active trader and a logically sarcastic idiot :)

Follow Me

Answer ( 1 )

Leave an answer

Name*

E-Mail*

Website

Attachment

Browse

Featured image

Browse

Answer*

Previous question

Next question

Payal Chuhan Member · Answer 1 · August 28, 2020

Payal Chuhan Member

0

August 28, 2020 at 7:05 am

Reply

Find the match date and the team name which were trained by the coach whose name ends with “Santos”.

Register Now

Login

Lost Password

Q6 | Guess the question

About TheDataMonkGrand Master

Related questions

The Given Data set, Table has transitive dependencies. Explain Which Attributes are partially dependent. How will you overcome this? Explain the approach?

Write a query to Plot a Relationship between the highest followers in every country (Country Wise Highest Followers) and show which country has the highest followers and which country has the lowest one. Explain the approach?

Write a Query to Find the account with the highest number of followers in every country. Explain the approach?

Assign Rank To each Category by authentic engagement in each country and return the category with a rank less than 3. Explain the Approach?

Write a Query to check for Missing values in the given table? Explain how will you deal with the missing data for qualitative and quantitative data?

Answer ( 1 )

Leave an answer