Question: Which query shows the first name, department, and team of all students with the two lowest points?

  1. `SELECT LIMIT(2) first_name, department, team FROM Students ORDER BY points ASC;`
  2. `SELECT TOP(2) first_name, deprtment, team FROM Students ORDER BY points DESC;`
  3. `SELECT TOP(2) WITH TIES first_name, department, team FROM Students ORDER BY points;`
  4. `SELECT BOTTOM(2) first_name, department, team FROM Students ORDER BY points ASC;`

Answer: The correct answer of the above question is Option C:`SELECT TOP(2) WITH TIES first_name, department, team FROM Students ORDER BY points;`