SQL: Annual and Quarterly Cryptocurrency Transactions Report

Problem Statement

SQL: Annual and Quarterly Cryptocurrency Transactions Report Problem Description A development team is building a report that summarises the transactions of every cryptocurrency for each quarter of the year 2023 , together with the number of transactions and the total transaction amount for the year. Write an SQL query that returns, for every cryptocurrency that has at least one transaction in 2023, its name, the total transaction amount in each quarter of 2023, the number of its 2023 transactions and its total 2023 transaction amount. Table: coins Column Type Description id INT Identifier of the cryptocurrency (primary key) name VARCHAR(255) Name of the cryptocurrency Table: transactions Column Type Description coin_id INT References coins.id dt VARCHAR(19) Date and time of the transaction, text in the form YYYY-MM-DD HH:MM:SS amount DECIMAL(5,2) Amount of the transaction Expected Output Return exactly these columns, in this order: Column Description name Name of the cryptocurrency q1