Write a SQL query to join two tables and find the total order volume for a specific marketplace seller over the last 30 days.
Use seller ID 101 and interpret the period relative to CURRENT_DATE, including both boundary dates.
seller_id, seller_name, and total_order_volume.| Column | Type | Description |
|---|---|---|
| seller_idPK | INT | Unique marketplace seller identifier |
| seller_name | VARCHAR(150) | Marketplace seller display name |
| Column | Type | Description |
|---|---|---|
| order_idPK | INT | Unique order identifier |
| seller_id | INT | Seller associated with the order |
| order_date | DATE | Date the order was placed |
| order_volume | NUMERIC(12,2) | Monetary order volume |