Write a query to Display all employees of mumbai and london reference to employes table and location table

Answer 1

select employes.ename, employess.empid, location.country,location.empid from employee natural join on country = "london" and employee.empid = location.empid

Answer 2

then on location.contry = "london" and location.city = "mumbai" where employee.empid = location.empid

Answer 3

for mumbai