/span> studentcourse;</span></code></pre></div>
<ul>
<li>We can restrict the view rows to a specific student, for a specific semester and year
<ul>
<li>could be useful when creating schedules</li>
</ul></li>
</ul>
<div class="sourceCode" id="cb9"><pre class="sourceCode sql"><code class="sourceCode sql"><span id="cb9-1"><a href="#cb9-1" aria-hidden="true"></a><span class="kw">select</span> <span class="op">*</span></span>
<span id="cb9-2"><a href="#cb9-2" aria-hidden="true"></a><span class="kw">from</span> s