title: mysql summary query with special condition
body: <p>I Have tables like below
  <a href="https://i.stack.imgur.com/mN66F.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/mN66F.png" alt="enter image description here"></a></p>
  
  <p>How is query to show summary data like above?</p>
  
  <p>NB: I was try, but my query result INDIA is 3. What i mean is only count company on period without count project with that period, so that the right result should is 2 like above</p>
  
  <p>Thank You</p>