Patients Living on Maple Ave
A social worker is visiting patients on Maple Ave to enroll them in a home-monitoring program. Output the full record of 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 | gender | address | birthday | last_name | first_name |
|---|---|---|---|---|---|
| 1 | f | 12 Maple Ave | 2005-03-15 | Owens | Mary |
| 3 | f | 8 Maple Ave | 2005-11-30 | Wright | Lisa |
| 6 | f | 20 Maple Ave | 2005-09-01 | Carter | Eve |
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign in