``` create table credit_card_transactions(transaction_time timestamp); create table my_timer(t timestamp); create view recent_transactions as SELECT * FROM credit_card_transactions WHERE transaction_time >= (SELECT t FROM my_timer) - INTERVAL 1 DAY; ```