How sql query to display records in the interval for the last hour but not earlier than half an hour?

Question

MySQL

Each entry has a registration date.
How to query records for the last hour, but not earlier than 30 minutes from the current time?

Answer 1

SELECT *
FROM tbl
WHERE registration >= DATE_SUB(NOW(), INTERVAL 30 MINUTE)