Fly Cup Challenge - Task 3

[shashank_adiga]

Facing errors while completing the task 3, here event_pilot_id is present outside the mentioned reference tables. So, where are we supposed to write the query and what's the joining method?

[brlikhon · Accepted solution]

SELECT `drl.pilots`.name, `drl.event_pilots`.id FROM `drl.event_pilots` LEFT JOIN `drl.pilots` ON `drl.pilots`.id = `drl.event_pilots`.pilot_id

[Sudhanshu103]

@brlikhon please can you provide solutions for fly cup challenge as  I am facing issues in solving it.

[SidVjSingh]

We can help you in getting the solution wherever you face problem, but asking for complete solution is not fair for those who have figured it out on their own and ranked themselves in top50.

[Sudhanshu103]

@SidVjSingh so please help me in task 5.

[SidVjSingh]

You just need to add table name and column name

[imharry404]

https://www.youtube.com/watch?v=DlzyOwppVTI

[pratiks2k03]

hey can anyone pls help me with this i am unable to register for the google next event i chose sign in with google and its stuck on details page from like 2 days