title: SQL select columns ordered by a query
body: <p>I have tried and googled everything I can think of but I couldn't find an answer I have this simple database </p>
  
  <p>technicien</p>
  
  <pre><code>+------------------+------------+------+-----+
  | Field            | Type       | Null | Key |
  +------------------+------------+------+-----+
  | employe id       | number(4)  | NO   | PRI |
  | name             | char(11)   | NO   |     |
  | salary           | int(11)    | NO   |     |
  +------------------+------------+------+-----+
  </code></pre>
  
  <p>maintenance </p>
  
  <pre><code>+------------------+------------+------+---------+
  | Field            | Type       | Null | Key     |
  +------------------+------------+------+---------+
  | employe id       | number(4)  | NO   | foreign |
  | IP               | char(11)   | NO   | foreign |
  | maintenance_date | int(11)    | NO   |         |
  +------------------+------------+------+---------+
  </code></pre>
  
  <p>pc</p>
  
  <pre><code>+------------------+------------+------+---------+
  | Field            | Type       | Null | Key     |
  +------------------+------------+------+---------+
  | value            | number(4)  | NO   | foreign |
  | IP               | char(11)   | NO   | PRI     |
  | price            | int(11)    | NO   |         |
  +------------------+------------+------+---------+
  </code></pre>
  
  <p>what I need is to show the name, id, and salary of every <code>technicien</code> who has done a <code>maintenance</code> ordered by the total number of maintenances effected.</p>