Can you solve this sql query?

Replies

• 

  blak

  select city_name,min(population) pop
  from
  (
  select city_name, population from table1
  union
  select city_name, population from table2
  union
  select city_name, population from table3
  union
  select city_name, population from table4
  )
  group by city_name
  order by pop;
• 

  ISHAN TOPRE

  select city_name,
  from table1, table2, table3, table4,
  where population<= P1, P2, P3, P4.