1. Consider the following Realtor database with three relations. Write SQL statements for creating a view called AgentsOfTheYear that will display the name and address of realtors who have sold a total amount of 5 million dollars' worth of properties in 2021.

RealtorAgent (realtor_no, name, age, address, commission_percentage)

Customer (C_ID, name, property_id, property_address, description, property_tax, property_value)

Transaction (realtor_no, C_ID, property_id, price_sold, date_sold)