Over-the-Counter Medications
Over-the-Counter Medications
On a pharmacy shift people often ask which medications they can buy straight off the shelf — no prescription required. Output the name and price of those (requires_prescription = false), sorted by 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.
| name | price |
|---|---|
| Aspirin | 4.50 |
| Ibuprofen | 5.80 |
| VitaminC | 6.20 |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid