title: Conditionals in SQL
body: <p>Let's say I have a simple SQL Table like this: <a href="http://sqlfiddle.com/#!2/ce3fd/2/0" rel="nofollow">http://sqlfiddle.com/#!2/ce3fd/2/0</a></p>
  
  <pre><code>CREATE TABLE Trends
  (Country varchar(250),
  CTR int);
  
  INSERT INTO Trends (Country, CTR)
  VALUES ('America', 5),
  ('America', 10),
  ('America', 12),
  ('America', 40),
  ('England', 10),
  ('England', 410),
  ('England', 310),
  ('England', 210);
  </code></pre>
  
  <p>I want to set up a conditional that </p>
  
  <p>A) Tests each individual country
  B) Returns that country only if the CTR for ALL VALUES of that country are above 10</p>
  
  <p>For example, in this table, "America" would not be returned because it has a CTR below 10. England would be returned because all if its CTRs are above 10.</p>
  
  <p>Would I use the CASE item here? </p>