title: Customer select
body: <p>I have customer table order table where I have <code>CustomerID</code> and <code>order date</code>. List the customers, giving for each the number of orders they have made as well as the
  dates of the first and the last order. Sort by the number of orders.
  I have just started to study SQL but I am not sure how to start.</p>
  
  <pre><code>SELECT customerId
        ,count(customerId)
        ,MAX(orderDate)
        ,MIN(orderDate) 
    FROM CustomerOrders
  </code></pre>