Domain Name Registrar Renewal Schedule Report

Problem Statement

Problem Description A domain name registration service is developing its billing functionality. Write a SQL query to generate a report detailing the annual renewal costs for all customer accounts, grouped by the top-level domains (TLDs) they own. This report must specifically target domains scheduled to expire in the calendar month of August 2022 . Schema accounts Table Column Name Type Description id SMALLINT Unique identifier for the account (Primary Key) username VARCHAR(255) Unique username for the account domains Table Column Name Type Description account_id SMALLINT Foreign key referencing accounts.id name VARCHAR(255) The full domain name (e.g., google.co ) expiration_date VARCHAR(19) Expiration date in YYYY-MM-DD string format prices Table Column Name Type Description tld VARCHAR(3) Top-level domain (e.g., com , co , gg ) price VARCHAR(6) Annual renewal price for the TLD, formatted as a string with a leading dollar sign (e.g., $8.98 ) Required Output The result should have the