title: Simple SQL task
body: <p>Two Tables</p>
  <p>Table name = profiles</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>UserRefID</th>
  <th>Firstname</th>
  <th>Surname</th>
  <th>Deceased</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>100567</td>
  <td>John</td>
  <td>Smith</td>
  <td>0</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Table name = emails</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>UserRefID</th>
  <th>emailID</th>
  <th>emailaddress</th>
  <th>Default</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>100567</td>
  <td>567</td>
  <td>j.smith@zmail.com</td>
  <td>1</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Write a short SQL select statement to retrieve all duplicate email addresses for the same UserRefID where the user is alive and at least one of the emails is a default email address.</p>
  <p>(The deceased and default fields are both Boolean)</p>