title: SQL questions - Medium difficulty
body: <p>I am working through this link and I am stuck on Q7 and Q8 on this website: <a href="http://sqlzoo.net/a3m.htm" rel="nofollow">http://sqlzoo.net/a3m.htm</a></p>
  
  <p>My attempt for Q7 is: </p>
  
  <pre><code>SELECT tprod.dscr, sum(qnty), max(tpurcd.recv)
  FROM tprod, tpurcd
  WHERE tprod.code = tpurcd.prod
  GROUP BY tprod.dscr, tpurcd.recv
  </code></pre>
  
  <p>Q8 attempt:</p>
  
  <pre><code>SELECT tpurcd.cust, tpurcd.recv, qnty
  FROM tpurcd, tprod
  WHERE tprod.code = tpurcd.prod
  AND tpurcd.qnty * tprod.pric
  </code></pre>
  
  <p>Table info is listed here: <a href="http://sqlzoo.net/a3.htm" rel="nofollow">http://sqlzoo.net/a3.htm</a></p>
  
  <p>Any help would be appreciated! </p>