Patients with Maple Ave in their address
A social worker is visiting patients on Maple Ave to offer them enrollment in a home-monitoring program. Return the full record for every patient whose address contains the substring Maple Ave.
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.
| id | first_name | last_name | birthday | address | gender |
|---|---|---|---|---|---|
| 1 | Mary | Owens | 2005-03-15 | 12 Maple Ave | f |
| 3 | Lisa | Wright | 2005-11-30 | 8 Maple Ave | f |
| 6 | Eve | Carter | 2005-09-01 | 20 Maple Ave | f |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid