title: Generating tag cloud count given these 3 tables
body: <p>I have these three table to store tags for photo albums.  Here is the schema</p>
  
  <p><strong>table 1: Albums</strong><br>
  Album_ID<br>
  Album_Name  </p>
  
  <p><strong>table 2: AlbumTags</strong><br>
  Tag_ID<br>
  Tag_Name  </p>
  
  <p><strong>table 3: AlbumTagBridge</strong><br>
  ID<br>
  Tag_ID<br>
  Album_ID </p>
  
  <p>What is the most efficient SQL to be able to come up with a result set that looks like this:</p>
  
  <p>Tag_Name | Count<br>
  Tag 1    |  19<br>
  Tag 2    |   3<br>
  Tag 3    |  17   </p>