title: Query to select limit in specific condition
body: <p>In my table, I have the 'email' column. I want to select 1000 data where max 100 emails are 'gmail'. Is there any way to write one query to get data?</p>
  <p>What I am doing is, to create two queries and then merge them.</p>
  <pre><code>SELECT email from my_table where email not like '%@gmail.%' limit 900;
  SELECT email from my_table where email like '%@gmail.%' limit 100;
  </code></pre>