title: Oracle SQL query count, group by with an innerjoin?
body: <p>Basicly I have a bunch of Cars that belong to dealers and the dealers have a group.
  The dealer table has the GROUP.ID and the Group table has the group name.
  A Group has multiple dealers</p>
  
  <p>So I want to count how many cars each group has.</p>
  
  <p>I am using this atm</p>
  
  <pre><code>select  
    (select GROUP_NAME from "GROUP" where "GROUP".GROUP_ID = "DEALER"."GROUP_ID" ),
    "DEALER"."GROUP_ID" as "DEALER GROUP ID",
    "DEALER"."DEALER_NAME" as "DEALER DEALER NAME",
    "CAR"."CAR_DEALER" as "CAR DEALER"         
  from 
    "CAR"
  INNER JOIN 
    DEALER
  ON 
    "DEALER"."DEALER_NAME" ="CAR"."CAR_DEALER"
  </code></pre>
  
  <p>I tried using <code>group_by</code> and <code>count</code> but I can't seem to get it to work</p>