ZS Associates Interview Question

How many traffic lights are there in Pune. Questions from sql espcially joins, subqueries.