I can't write sql query, how can I do it?

Question

MySQL

There is a MySQL table with fields “ID”, “prod”. Write an SQL query that will return the Prod field of the record with the fifth largest ID from the end (for example, if the table records with ID = 1,2,3,6,7,8,10,25,31,32 need entry for ID=8).

Answer 1

Homework? Read the manual.

Answer 2

SELECT 'prod' 
FROM  'table' 
ORDER BY 'table'.'id'  DESC
LIMIT 4 , 1