count number of property available for member according to there zip code
<p>i have two table</p>

<p>1) member</p>

<ul>
<li>member_id</li>
<li>name</li>
<li>address</li>
<li>zip</li>
</ul>

<p>2) property</p>

<ul>
<li>property_id</li>
<li>property_name</li>
<li>property_zip</li>
</ul>

<p>i want to list all the member zip (without duplicate) and show the count of property for each zip code in a table</p>

<hr>

<h2>Member Zip | Property Count</h2>

<h2>95674      |   50</h2>

<h2>95852      |   90</h2>

<h2>95614      |   0</h2>

<h2>95070      |   5</h2>

<p>its have multiple member with same zip code and also multiple property with same zip code  </p>

<p>i don't want any repeat on the Member Zip output column.  </p>

<p>i have 5 member with 92550 &amp; 10 member with 82475, i have to show  </p>

<p>92550<br>
82475</p>

<p>&amp; on property table i have 10 with zipcode 82475 and 4 with zip code 92550.  </p>

<p>Final O/P  </p>

<p>92550 (4)<br>
82475 (10)</p>

<p>can anyone help me to find it ?</p>
