What SQL Statement can be used to access this information? : <p>I'm trying to write an <code>SQL</code> statement that can be used in <code>PHP</code> for a website, but am having trouble comprehending how to access the information.</p>

<p>I have the following tables..
<a href="https://i.stack.imgur.com/Yvypl.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Yvypl.png" alt="enter image description here"></a>
<strong>Please Note:</strong> <code>ACADEMIC_ID</code> &amp; <code>STUDENT_ID</code> are just foreign keys for <code>USER_ID</code>.</p>

<p>My desired result is..
<a href="https://i.stack.imgur.com/df7ez.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/df7ez.png" alt="enter image description here"></a></p>

<p>As I am trying to gain access to the information from the Students View of the website in <code>PHP</code>, I only have the following information to work with..</p>

<ol>
<li>The <code>USER_ID</code> of the student. </li>
<li>The <code>DEBATE_ID</code> for each of the debates the student is currently enrolled in.</li>
</ol>

<p>Therefore..</p>

<blockquote>
  <p><em>What SQL statement can be used to give the desired result?</em></p>
</blockquote>
