Describe a time you used SQL to identify an inefficiency in a data set.
Use the provided tables to identify repeated settled execution records sharing the same account, instrument, timestamp, quantity, and price. Treat records with a missing or unmatched instrument reference as identifiable records rather than excluding them.
account_id, instrument_symbol, executed_at, quantity, price, duplicate_count, excess_rows, total_quantityexcess_rows descending, then account and timestamp ascending| Column | Type | Description |
|---|---|---|
| execution_idPK | INT | Unique execution record identifier |
| account_id | VARCHAR(20) | Trading account identifier |
| instrument_id | INT | Referenced instrument identifier |
| executed_at | TIMESTAMP | Execution timestamp |
| quantity | INT | Executed quantity |
| price | NUMERIC(12,2) | Execution price |
| status | VARCHAR(20) | Execution processing status |
| Column | Type | Description |
|---|---|---|
| instrument_idPK | INT | Unique instrument identifier |
| symbol | VARCHAR(20) | Instrument symbol |
| asset_class | VARCHAR(30) | Instrument asset class |