title: SQL query select client that has the most orders placed
body: <p>I want to select the client that has the most orders placed: </p>
  
  <p>I have 2 tables :</p>
  
  <pre><code>CREATE TABLE customers(
  customerid INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY,
  NAME CHAR(50) NOT NULL,
  address CHAR(100) NOT NULL,
  city CHAR(30)NOT NULL
  );
  
  
  CREATE TABLE orders(
  orderid INT UNSIGNED NOT NULL,
  customerid INT UNSIGNED NOT NULL,
  );
  </code></pre>
  
  <p>This is what i am trying to do: </p>
  
  <pre><code>SELECT customers.customerid, customers.name,orders.orderid, COUNT(customerid) 
  AS CostumerCount 
  FROM customers 
  INNER JOIN orders 
  ON customers.customerid=orders.orderid; 
  </code></pre>
  
  <p>How can i make this?  </p>