Question

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

a) SELECT FirstName, Department, Team FROM Students ORDER BY Points LIMIT 2;
b) SELECT FirstName, Department, Team FROM Students ORDER BY Points OFFSET 2;
c) SELECT FirstName, Department, Team FROM Students WHERE Points IN (SELECT MIN(Points) FROM Students LIMIT 2);
d) SELECT FirstName, Department, Team FROM Students ORDER BY Points LIMIT 2 OFFSET 0;

Answer 1

The correct SQL query to select students with the two lowest points is option a), which uses ORDER BY Points along with LIMIT 2 to return the desired result set.

Step-by-step explanation:

The query that shows the first name, department, and team of all students with the two lowest points is:

a) SELECT FirstName, Department, Team FROM Students ORDER BY Points LIMIT 2;

This SQL query selects the relevant columns and orders the results by the Points column in ascending order (lowest to highest by default), displaying only the top 2 records with the lowest points using the LIMIT clause.

Option b) would skip the first two records due to the OFFSET, option c) is incorrect because there can only be one MIN(Points), and there is no standard SQL that supports LIMIT within an IN subquery, and option d) is redundant as the OFFSET 0 defaults to the start of the result set without skipping any rows.