title: I want to join 3 tables from this data
body: <p>I have 3 tables.</p>
  
  <p><strong>customers</strong></p>
  
  <pre><code>-------------------
  custID | custName |
  -------------------
     1   | 1        |
     2   | 2        |
     3   | 3        |
  -------------------
  </code></pre>
  
  <p><strong>cars</strong></p>
  
  <pre><code>-------------------
  carID  | custID   |
  -------------------
    A    | 1        |
    B    | 1        |
    C    | 2        |
    D    | 2        |
    E    | 3        |
  -------------------
  </code></pre>
  
  <p><strong>bill</strong></p>
  
  <pre><code>-------------------------------------
  billNo | carID | custID | billTotal |
  -------------------------------------
  1      |   A   | 1      | 100       |
  2      |   B   | 1      | 100       |
  3      |   D   | 2      | 100       |
  4      |   E   | 3      | 100       |
  5      |   A   | 1      | 100       |
  6      |   C   | 2      | 100       |
  7      |   C   | 2      | 100       |
  8      |   E   | 3      | 100       |
  9      |   B   | 1      | 100       |
  10     |   D   | 2      | 100       |
  11     |   A   | 1      | 100       |
  12     |   E   | 3      | 100       |
  13     |   E   | 3      | 100       |
  14     |   B   | 1      | 100       |
  -------------------------------------
  </code></pre>
  
  <p>I want to make JOIN 3 tables as illustrated below.</p>
  
  <pre><code>----------------------------------------
  custID | custName | countCar | sumBill |
  ----------------------------------------
  1      | 1        |    2     |   600   |
  2      | 2        |    2     |   400   |
  3      | 3        |    1     |   400   |
  ---------------------------------------
  </code></pre>
  
  <p>what SQL code can make it show this result???
  what SQL code can make it show this result???
  what SQL code can make it show this result???
  what SQL code can make it show this result???
  what SQL code can make it show this result???</p>
  
  <p>PS.my english is not well.</p>