title: Display a query with name salary and commission for all employees
body: <p>I have a question about SQL - this is my code so far:</p>
  
  <pre><code>SELECT ename,sal,comm
  FROM emp
  ORDER BY sal,comm  desc;
  WHERE comm&gt;0;
  </code></pre>
  
  <p>I need to display the name, salary and commission for all employees who earn commission, and sort the data out in descending order of salary and commission.</p>