title: Using DISTINCT inside a COUNT with CakePHP 3
body: <p>I'm new with CakePHP 3 and I want to know how I can use a DISTINCT inside a COUNT such as the following SQL query.</p>
  
  <pre><code>SELECT `column_one`, COUNT(DISTINCT `column_two`) FROM `table` GROUP BY `column_one`
  </code></pre>