How do you manipulate data structures in Python?
For this SQL data-manipulation version, use the provided users and transactions tables to summarize completed transaction activity for every user. Include users without completed transactions and classify their activity level.
user_id, user_name, completed_transaction_count, completed_amount, and activity_level.completed_amount descending, then user_id ascending.| Column | Type | Description |
|---|---|---|
| user_idPK | INTEGER | Unique user identifier |
| user_name | VARCHAR(100) | User display name |
| Column | Type | Description |
|---|---|---|
| transaction_idPK | INTEGER | Unique transaction identifier |
| user_id | INTEGER | User associated with the transaction |
| amount | NUMERIC(12,2) | Transaction amount |
| status | VARCHAR(40) | Current transaction status |