title: How do I write a SQL statement for this question?
body: <p><code>CHAMPIONS</code> (~500 rows)</p>
  
  <pre><code>YEAR COUNTRY NAME             ROLE
  2018 France  Didier Deschamps Manager
  2018 France  Hugo Lloris      Goalkeeper
  2018 France  Paul Pogba       Midfielder
  2014 Germany Joachim Loew     Manager
  2014 Germany Mesut Ozil       Midfielder
  2014 Germany Miroslav Klose   Forward
  2002 Brazil  Da Silva         Midfielder
  1994 Brazil  Da Silva         Midfielder
  1998 France  Didier Deschamps Midfielder
  </code></pre>
  
  <p>Write a query showing how many times each country has won the world cup for countries winning the world cup at least twice.</p>
  
  <p>What I am confused about is, the how many times each country has won it, when for example there is France 3 times in 2018. I'm not sure if i need a count option or select statement.</p>
  
  <p>I'd be grateful for extra clarification and help with this, or if my query needs any tweaking.</p>
  
  <p>What I have tried:</p>
  
  <p>This is what I came up with:</p>
  
  <pre><code>SELECT YEAR, COUNTRY
  FROM CHAMPIONS
  WHERE COUNTRY&gt;=2;
  </code></pre>
  
  <p>I hope this is right.</p>