title: SQL Query: Complex Inner Joins and Outer Joins
body: <p>Hi everyone I am currently working on an SQL sample project, trying to learn the basics of SQL and inner outer joins in general.</p>
  
  <p>This is my current Database diagram:</p>
  
  <p><a href="http://imgur.com/z0Ger" rel="nofollow">http://imgur.com/z0Ger</a></p>
  
  <p>I am currently stuck on 2 different queries that I am having trouble writing.</p>
  
  <pre><code>1. Given a puppy name show all the tricks it knows. 
  
  Include:
  Dog id &amp; name
  Trick id &amp; name
  Date learned &amp; skill level
  
  2. Given a kennel show all the puppies that have been there to learn a trick.
  
  Include:
  Kennel id &amp; name
  Date learned &amp; trick id
  Dog id &amp; dog name
  </code></pre>
  
  <p>I really am stumped on these and would really appreciate it if you can help lead me to the right answer. Any help is appreciated. Thanks</p>