title: SQL Relational query Help Student Do Sport
body: <p>Im doing a test exam where I've gotten stuck on one particular query, in both its SQL code, relational algebra and tuple relational calculus.</p>
  
  <p>here scenario.</p>
  
  <p>I have 3 tables </p>
  
  <h1>Student (reg_no, name, address)</h1>
  
  <h2>Heading</h2>
  
  <h1>Sport (sportId, title)</h1>
  
  <h1>Student_Sport(reg_no,sportId,Year,Capacity)</h1>
  
  <p>In Capacity Field values are Captain, Vice Captain, Member</p>
  
  <p>I Want to get list of sport that has no captains.</p>
  
  <p>Any one Help Me?</p>