Products with Proper Serials
Products with Proper Serials
Return products whose serial_number matches exactly the pattern SN- + exactly 4 digits (e.g. SN-1234). Return product_id and product_name.
Expected output sample
This is what a correct answer looks like — its row count is its own, it doesn't have to match the schema tables. Your answer must use the same column names as this sample — alias them with AS if needed.
| product_id | product_name |
|---|---|
| 1 | Widget |
| 3 | Thing |
| 7 | Nut |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid