title: MySQL said: #1241 - Operand should contain 1 column(s)
body: <pre><code>SELECT
    student.Student_Name
  FROM
    `student`
  GROUP BY
    student.Student_ID,
    teacher.Department_No IN (
      SELECT
        teacher.Department_No
      FROM
        `teacher`, `building`
      WHERE
        teacher.Department_No BETWEEN 1000
        AND 2999
      GROUP BY
        teacher.Department_No = (
          SELECT
            *
          FROM
            `building`
          WHERE
            building.Building_No IN ( '1', '2') 
        )
    ) LIMIT 0, 25
  </code></pre>