Hello All,
I have been given a task to find out players scored in both champions league and premier league and i should not use where clause.
Info:
The table consist of Columns( Player_name, Club_name,League_name,Goals_Tally)
Few players scored in both champions league and premier league and few just scored in premier league alone.
I want to get a result where player scored in both leagues. I think for this result i should use SQL functions to get the result.
Any help on this would be greatly appreciated.
Table 
Thanks