title: writing an sql query to show names of guests who had both charges?
body: <pre><code>SELECT GUEST.FIRSTNAME,GUEST.LASTNAME, CHARGETYPE.DESCRIPTION
  FROM GUEST
  INNER JOIN CHARGES
  ON GUEST.GUESTID = CHARGES.GUESTID
  INNER JOIN CHARGETYPE
  ON  CHARGETYPE.CHARGEID = CHARGES.CHARGEID
  WHERE CHARGES.CHARGEID IN ('07','03' );
  </code></pre>
  
  <p>-DEAN       JOHNSON     DINNER SERVICE</p>
  
  <p>-DEAN       JOHNSON     DINNER SERVICE</p>
  
  <p>-JANE       ADAMS       DINNER SERVICE</p>
  
  <p>-PETER      ADAMS       DINNER SERVICE</p>
  
  <p>-PETER      ADAMS       DINNER SERVICE</p>
  
  <p>-JOHN       SMITH       DINNER SERVICE</p>
  
  <p>-JOHN       SMITH       DINNER SERVICE</p>
  
  <p>-DEAN       JOHNSON     ATHLETIC CHARGE</p>
  
  <p>-JOHN       SMITH       ATHLETIC CHARGE</p>
  
  <p>The output should only show that DEAN and JOHN had BOTH athletic and dinner service charges. Is there any easy way to fix this? </p>