title: Show 2 COUNT syntax on one SELECT
body: <p>i have a table from the book list</p>
  
  <pre><code>+---------+-------------------------+------------------+-------------+-------+----------+
  | ID      | Title                   | Writer           | Publisher   | year  | Status   |
  +---------+-------------------------+------------------+-------------+-------+----------+
  | S00001  | philosophy the intro    | K. Bertens.      | Kanisius    | 2018  | BOOKED   |
  | S00002  | Karl Marx: Das Kapital  | Karl Marx        | el-Classica | 2017  | READY    |
  | S00003  | Karl Marx: Das Kapital  | Karl Marx        | el-Classica | 2017  | READY    |
  | S00004  | Karl Marx: Das Kapital  | Johann Luwiss    | Mediatama   | 2015  | READY    |
  | S00005  | Marxis                  | Karl Marx        | Photoem     | 2019  | READY    |
  | S00006  | Karl Marx: Das Kapital  | Karl Marx        | el-Classica | 2017  | BOOKED   |
  | S00007  | philosophy the intro    | K. Bertens.      | Kanisius    | 2018  | READY    |
  +---------+-------------------------+------------------+-------------+-------+----------+
  </code></pre>
  
  <p>first and can show the count from duplicate of title and Writer group by TITLE and Writer but i cant show COUNT from the status where its 'READY' on every single row.</p>
  
  <p>the result should be like this</p>
  
  <pre><code>+-------------------------+-----------------+-------+------+
  | Title                   | Writer          | Ready | stock|
  +-------------------------+-----------------+-------+------+
  | Marxis                  | Karl Marx       | 1     |    1 |
  | Karl Marx: Das Kapital  | Johann Luwiss   | 1     |    1 |
  | Karl Marx: Das Kapital  | Karl Marx       | 2     |    3 |
  | philosophy the intro    | K. Bertens.     | 1     |    2 |
  +-------------------------+-----------------+-------+------+
  </code></pre>