Query in sql server

Question

Hello Developers


I have three tables named

tb_fst_form

id    district   identification

1     Amritsar     yes

2     Amritsar     yes

3     Bathinda     Yes

4     Barnala      Yes

tb_second_form

id    district   identification

1     Gurdaspur     yes

2     Amritsar      yes

3     Bathinda      Yes

4     Barnala       Yes


tb_third_form

id    district   identification

1     Tarntaran     yes
 
2     Amritsar      yes

3     Bathinda      Yes

4     Barnala       Yes




Now i need an sql query to fetch combine records from three tables district wise


Like


District      fst_table_count      second_table_count      third_table_count


Tarntaran        0                         0                             1

Amritsar         2                          1                             1

Barnala          1                          1                             1

Bathinda        1                          1                             1

Gurdaspur      0                          1                             0

Please help me to create the mysql query

Thanks

Bharat Bhushan