title: How to query fields and count in Ecto?
body: <p>Is it possible to write the following SQL in Ecto3?
  As I'd like to write a pagination logic at last, the inner count SQL should return the count to match the condition in the inner SQL not the condition in the outer one.</p>
  
  <blockquote>
    <p>SELECT id, (SELECT count(*) FROM questions WHERE id>10) AS count FROM questions WHERE id > 10 LIMIT 3 OFFSET1;</p>
  </blockquote>
  
  <p>Update: DB is mysql</p>