title: Find the total number of people who owned cars in MySQL given the schema
body: <p>hey guys im doing some revision for exam and going through past papers can someone tell me if im on the right track.</p>
  
  <p>Consider the insurance database given below: </p>
  
  <pre><code>person (driver-id, name, address)&lt;br&gt;
  car (license, model, year)&lt;br&gt;
  accident (report-number, date, location)&lt;br&gt;
  owns (driver-id, license) &lt;br&gt;
  participated (driver-id, car, report-number, damage-amount)&lt;br&gt;
  </code></pre>
  
  <p>1)Find the total number of people who owned cars that were involved in accidents in 2004. </p>
  
  <p>here is what i came up with:</p>
  
  <pre><code>SELECT COUNT(driver-id)
  FROM participated
  WHERE participated.reportnumber=accident.reportnumber
  AND accident.date = 2004
  </code></pre>
  
  <p>am i on the right track? any help would be appreciated.</p>