Given 3 tables (Children, Toys, Asks), list the toys most asked by children under 9, sorted alphabetically.
This is a SQL query task based on a multi-table schema. Use the child age to filter the requests and return the toy names that appear in those requests.
toy_nametoy_name| Column | Type | Description |
|---|---|---|
| child_idPK | INT | Unique identifier for each child |
| child_name | VARCHAR(100) | Child name |
| age | INT | Child age in years |
| Column | Type | Description |
|---|---|---|
| toy_idPK | INT | Unique identifier for each toy |
| toy_name | VARCHAR(100) | Toy name |
| Column | Type | Description |
|---|---|---|
| ask_idPK | INT | Unique identifier for each ask |
| child_id | INT | References children.child_id |
| toy_id | INT | References toys.toy_id |