-- Suggested testing environment: -- https://www.db-fiddle.com/ with MySQL version set to 8 -- Example case create statement: CREATE TABLE registrations ( id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(50) NOT NULL, create_date DATE NOT NULL, last_activity DATE NOT NULL ); INSERT INTO registrations (name, create_date, last_activity) VALUES ('John', '2010-4-25', '2010-4-30'), ('Eva', '2010-5-15', '2010-5-25'), ('Robbert', '2010-5-22', '2011-1-25'), ('Maria', '2010-6-08', '2010-7-25'); -- Fill in the blanks in the following statement: SELECT name, create_date, last_activity FROM registrations WHERE _____________ >= __________(__________, INTERVAL 30 DAY); -- Expected output (in any order): -- name create_date last_activity -- ----------------------------------------- -- Robbert 2010-05-22 2011-01-25 -- Maria 2010-06-08 2010-07-25