title: write inner join query in django
body: <p>i have two tables and need to write this query in django</p>
  
  <p>my models are:</p>
  
  <pre><code>class students(models.Model):
      name = models.CharField(max_length=30)
      active = models.BooleanField(max_length=1)
  
  class college(models.Model):
      department = models.CharField(max_length=20)
      college_name = models.CharField(max_length = 50)
      s_id = models.ForeignKey(students, on_delete=models.CASCADE)
  </code></pre>
  
  <p>my mysql query:</p>
  
  <pre><code>select b.name,a.department from college as a 
  inner join students as b on (a.s_id = b.id) 
  where (a.department = 'CSE' AND b.active = 1)
  </code></pre>
  
  <p>i just want to write this query in django</p>