Your question is SQL Inner Join. Start with the requirements and the one table on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Wolfspeed's manufacturing systems track production lots for silicon carbide wafer processing. Write a PostgreSQL query that returns only released lots from the Epi process area.
process_area is Epi and lot_status is Released.lot_number in ascending order.| Column | Type | Description |
|---|---|---|
| lot_idPK | INTEGER | Unique production lot identifier |
| lot_number | VARCHAR(20) | Manufacturing lot number |
| process_area | VARCHAR(30) | Manufacturing process area |
| lot_status | VARCHAR(20) | Current lot status |
| wafer_count | INTEGER | Number of wafers in the lot |