Company: jubliant_19sep
Difficulty: medium
Problem Description Write a SQL query to generate a report of Ethereum wallets and their total balances based on confirmed transactions. Schema Table: wallets +-------------+--------------+-------------------------+ | Column Name | Type | Description | +-------------+--------------+-------------------------+ | id | SMALLINT | Unique ID, Primary Key | | address | VARCHAR(255) | Ethereum wallet address | +-------------+--------------+-------------------------+ Table: transactions +---------------+--------------+--------------------------+ | Column Name | Type | Description | +---------------+--------------+--------------------------+ | wallet_id | SMALLINT | Foreign Key (wallets.id) | | amount | DECIMAL(6,3) | Transaction amount | | confirmations | SMALLINT | Number of confirmations | +---------------+--------------+--------------------------+ Required Output Your query should return a result set with the following columns: address : The Ethereum wallet address. num_confirmed_transaction