title: PostgreSQL query issue 2
body: <p>The relations are:</p>
  
  <pre><code>Event (etype, description)                     primary key - etype
  
  City (cname, country, population)              primary key - cname
  
  Disaster (cname, dyear, etype, casualties)     primary key - cname, dyear
  </code></pre>
  
  <p>I need to write a query which tells which country faced all types (etype in relation) of disasters.</p>
  
  <p>How do i do that?</p>
  
  <p>I have this so far:</p>
  
  <pre><code>select country
  from city natural join disaster, (select count(etype) as a
                                    from event) as A
  group by country, etype
  having count(country) = max(A.a)
  </code></pre>