Write an SQL query to return an average price of specific ids.
Use the supplied product and price data. For grading, use product IDs 101, 103, 105, and 999. Return only requested IDs with at least one matching price record.
product_id, average_priceaverage_price to two decimal places and sort by product_id ascending| Column | Type | Description |
|---|---|---|
| product_idPK | INT | Unique product identifier |
| product_name | VARCHAR(100) | Product name |
| Column | Type | Description |
|---|---|---|
| price_idPK | INT | Unique price record identifier |
| product_id | INT | Product associated with the price record |
| price | NUMERIC(10,2) | Recorded product price |