title: Get the TOP 10 Countries have peoples age 40+ from their DOB ? SQL
body: <p>i have table Persons where i have feilds</p>
  
  <pre><code>   pID , pName  , pDateOfBirth  , pCountry 
  </code></pre>
  
  <p>now i have 10thousand peoples or above in database</p>
  
  <p><strong>Question?</strong> I want TOP 10 Name of coutries that is pCountry have persons age 40+?</p>
  
  <p>my effort for that is </p>
  
  <pre><code> select TOP 10  Count(pid) as ratio ,PCountry, datediff(pDOB, Date.Now) as 
   age where age &gt;  '40' Group By country
  </code></pre>
  
  <p>what i want is this </p>
  
  <pre><code>      Pak = 555
        INDIA = 6666
        USA= 88
        Aus = 557
  </code></pre>
  
  <p>etc</p>