title: Getting a count of distinct counts in mySql
body: <p>I have two Tables  one for Teams   one for Players  What I am trying to find out is the total head count table,  In other words I want to have a count of the total number of teams that have 2 members,  the to all number of teams that have 3 members  etc</p>
  
  <p>Here is the database structure.  </p>
  
  <p>(Sidebar Question: I'm a newbee here:  Is there a better way to post the SQL?  )</p>
  
  <pre><code>CREATE  TABLE `formsfiles`.`Teams` (
    `ID` INT NOT NULL AUTO_INCREMENT ,
    `Name` VARCHAR(45) NULL ,
    PRIMARY KEY (`ID`) );
  
  
  INSERT INTO `Teams` (`Name`) VALUES ('Sharks');
  INSERT INTO `Teams` (`Name`) VALUES ('Jets');
  INSERT INTO `Teams` (`Name`) VALUES ('Fish');
  INSERT INTO `Teams` (`Name`) VALUES ('Dodgers');
  
  
  CREATE  TABLE `Players` (
    `ID` INT NOT NULL AUTO_INCREMENT ,
    `Name` VARCHAR(45) NULL ,
    `Team_ID` INT NULL ,
    PRIMARY KEY (`ID`) );
  
  INSERT INTO `Players` (`Name`, `Team_ID`) VALUES ('Jim', '1');
  INSERT INTO `Players` (`Name`, `Team_ID`) VALUES ('Tom', '1');
  INSERT INTO `Players` (`Name`, `Team_ID`) VALUES ('Harry', '2');
  INSERT INTO `Players` (`Name`, `Team_ID`) VALUES ('Dave', '2');
  INSERT INTO `Players` (`Name`, `Team_ID`) VALUES ('Tim', '3');
  INSERT INTO `Players` (`Name`, `Team_ID`) VALUES ('Trey', '4');
  INSERT INTO `Players` (`Name`, `Team_ID`) VALUES ('Jay', '4');
  INSERT INTO `Players` (`Name`, `Team_ID`) VALUES ('Steve', '4');
  INSERT INTO `Players` (`Name`, `Team_ID`) VALUES ('Chris', '4');
  </code></pre>
  
  <p>What I want is a count Team sizes.</p>
  
  <p>I would like to see the following output</p>
  
  <pre><code>Team_Size  Count
  1          1
  2          2
  4          1
  </code></pre>