The best possible answer is
number of students with the last name Smith
A query uses the "SELECT" statement to extract data from the database. In the example above, if you have a students’ table, you might want to issue an SQL statement that returns the number of students with the last name Smith. This request to the database can be performed in a relational database.