title: How to list the amount of movies each actor has starred in
body: <p>I have a table which lists out the movies that a certain actor has starred in. The table looks something like this:</p>
  
  <pre><code>      CELEB          | MOVIE
  ------------------------------------------
  Pamela Anderson      | Borat: Cultural Learnings of America for Make Benefit Glorious Nation of Kazakhstan
  Pamela Anderson      | The Flintstones: Little Big League
  Pamela Anderson      | Pauly Shore Is Dead
  Pamela Anderson      | Roast of Pamela Anderson: Uncensored
  Pamela Anderson      | Snapdragon
  Jerry Seinfeld       | The Ratings Game
  Jerry Seinfeld       | Pros &amp; Cons
  Jerry Seinfeld       | Hindsight Is 20/20
  </code></pre>
  
  <p>And the list would go on for every movie each celebrity has starred in. Now I'm trying to write sql query to find the amount of movies that each actor as starred in. I know how to list out all the movies that a specific actor has done:</p>
  
  <pre><code>Select COUNT(MOVIE)
  From MOVIES_TABLE
  Where CELEB = "Jerry Seinfeld"
  </code></pre>
  
  <p>But I don't know how to list out the number of movies each actor has done and then list them in descending order. </p>