Question: Which query shows the first name, department, and team of all students with the two lowest points?
- `SELECT LIMIT(2) first_name, department, team FROM Students ORDER BY points ASC;`
- `SELECT TOP(2) first_name, deprtment, team FROM Students ORDER BY points DESC;`
- `SELECT TOP(2) WITH TIES first_name, department, team FROM Students ORDER BY points;`
- `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;`