title: Summarize count of multi table in single SQL query
body: <p>I have three table with below details:</p>
  <p>Table 1: worklog</p>
  <pre><code>+-----------+------------+-------------+
  | worklogid | technician | description |
  +-----------+------------+-------------+
  | 1         | john       | some text   |
  +-----------+------------+-------------+
  | 2         | jack       | some text   |
  +-----------+------------+-------------+
  | 3         | john       | some text   |
  +-----------+------------+-------------+
  | 4         | jenifer    | some text   |
  +-----------+------------+-------------+
  </code></pre>
  <p>Table 2: task</p>
  <pre><code>+--------+-------+-------------+
  | taskid | owner | description |
  +--------+-------+-------------+
  | 1      | john  | some text   |
  +--------+-------+-------------+
  | 2      | john  | some text   |
  +--------+-------+-------------+
  | 3      | john  | some text   |
  +--------+-------+-------------+
  | 4      | jack  | some text   |
  +--------+-------+-------------+
  </code></pre>
  <p>Table 3: request</p>
  <pre><code>+-----------+------------+-----------+-------------+
  | requestid | technician | title     | description |
  +-----------+------------+-----------+-------------+
  | 1         | john       | some text | ...         |
  +-----------+------------+-----------+-------------+
  | 2         | sara       | some text | ...         |
  +-----------+------------+-----------+-------------+
  | 3         | john       | some text | ...         |
  +-----------+------------+-----------+-------------+
  | 4         | jack       | some text | ...         |
  +-----------+------------+-----------+-------------+
  </code></pre>
  <p>Now I need to SQL query for this result:</p>
  <pre><code>+------------+------------------+---------------+------------------+
  | technician | count(worklogid) | count(taskid) | count(requestid) |
  +------------+------------------+---------------+------------------+
  | john       | 2                | 3             | 2                |
  +------------+------------------+---------------+------------------+
  | jack       | 1                | 1             | 1                |
  +------------+------------------+---------------+------------------+
  | jenifer    | 1                | 0             | 0                |
  +------------+------------------+---------------+------------------+
  | sara       | 0                | 0             | 1                |
  +------------+------------------+---------------+------------------+
  </code></pre>
  <p>What should I do?</p>