title: SQL movie database querying
body: <p>I'm having trouble solving the following SQL requests:</p>
  
  <ol>
  <li><p>Give the names of the actors that have acted in more films than 'sara allgood' and who have acted in films that won the 'cannes film festival'. Also, give the filmname.</p></li>
  <li><p>Get the percentage of movies who won awards out of all movies produced between the years 1970 and 1990.</p></li>
  </ol>
  
  <p>There are several tables but I'm assuming that only 4 are needed: 
  'films','remakes','casts', 'awtypes'</p>
  
  <ul>
  <li><p>'films' attributes: filmid, filmname, year, director, studio, award </p></li>
  <li><p>'remakes' attributes: filmid, title, year, priorfilm, prioryear</p></li>
  <li><p>'casts' attributes: filmid, filmname, actor, award(10)</p></li>
  <li><p>'awtypes' attributes: award(10), org(100), country, colloquial(50), year</p></li>
  </ul>
  
  <p>It's a bit unclear to me how to match the award to the 'Cannes film festival' in the first query since the award field is only 10 characters meaning it is a reference to the awtypes table but I don't know which field in the awtypes table contains the name of the award and I don't have access to the database at the moment so it's either org or colloquial.</p>
  
  <p>As for the second I don't know how I could compute the percentage but it seems that it should be solved using a union operator for the movies produced between 1970 and 1990 and the films that have won an award (I don't know how to place a condition for having at least one award). </p>