[Not a question] I have two table Employee(EName, ESalary, ELocation) and Locations(s.no, Location). I want to print number of employees in each city.

You have not been clear about the table schemas, but assuming that [s.no] is the primary key on table [locations] and[Location] contains the name; and that [ELocation] provides the foreign key to that table on [Employee] then you want something like this...

select Location, count(Ename) 
from locations L
LEFT OUTER JOIN Employee E ON L.[s.no]=E.ELocation
GROUP BY Location

Note that I've surrounded [s.no] with square brackets as the period (.) in the name is not valid otherwise

This query should return the expected results in your post