There are 2 tables and I have to join both the tables.
Table A has few columns but both tables have “city_code” column.
Table A has unique records if we talk about “city_code”. Only 1 “city_code” can be entered.
But Table B doesn’t have unique record if we talk about “city_code”.
There might be more than 1 record which has same “city_code”. I have to apply group by on table A behalf of Table A column name “status” and have to apply a filter on column “user_name” which is available in Table B.