39.3k views
1 vote
Create a statement that always returns the names of the three criminals with the highest number of crimes committed.

1 Answer

1 vote

Answer:

SELECT TOP 3 crimes_committed FROM criminals_and_crimes

Step-by-step explanation:

Assuming the questions requires an SQL statement, we need to order the list of the criminals by the number of crimes committed.

Let's assume the criminal names are stored under criminal_name and number of crimes committed is stored under num_of_crimes in a list named criminals_and_crimes

We can write:

SELECT TOP 3 crimes_committed FROM criminals_and_crimes

for MySQL.

I hope this answer helps.

User Cwt
by
5.2k points