SQL: Annual and Quarterly Cryptocurrency Transactions Report

Problem Statement

Problem Description Write a SQL query to generate a report summarizing cryptocurrency transaction volumes for the year 2023. The report should detail the total transaction amount per quarter, the total number of transactions, and the overall total transaction amount for each cryptocurrency throughout the year. Schema coins Table Column Name Data Type Constraints Description id INT PRIMARY KEY The unique identifier for the cryptocurrency coin. name VARCHAR(255) The name of the cryptocurrency. transactions Table Column Name Data Type Constraints Description coin_id INT FOREIGN KEY (references coins.id ) The reference to the cryptocurrency coin. dt VARCHAR(19) The date and time of the transaction (e.g., '2023-01-06 16:49:26'). amount DECIMAL(10,2) The transaction amount. Required Output The output should include the following columns in this exact order: name : The name of the cryptocurrency. q1_amount : Total transaction amount in Q1 2023 (Jan - Mar). q2_amount : Total transaction amount