runtimetask DISTINCT · warm-up
Borough and service-zone combinations
Return each distinct pair of borough_id and service_zone found in zones.
what to return
- Columns
borough_idservice_zonein this order- Rows
- 10 rows · any order
- Skill
- Return each distinct combination once. Refresher: Unique values with DISTINCT →
expected result
Your query should return exactly these columns and values. Run it and compare.
expected result10 rows · any order
| borough_id | service_zone |
|---|---|
| 1 | EWR |
| 2 | Boro Zone |
| 3 | Boro Zone |
first 3 of 10 rows
data you can query
Mobility dataset: the first 6 rows of each table. Under each column name: the kind of value it holds, and which table it links to. Your queries run on all rows.
zones5 columns · 265 rows
| zone_idnumber · unique id | zone_nametext | borough_idnumber · links to boroughs | service_zonetext | is_airportnumber |
|---|---|---|---|---|
| 1 | Newark Airport | 1 | EWR | 1 |
| 2 | Jamaica Bay | 2 | Boro Zone | 0 |
| 3 | Allerton/Pelham Gardens | 3 | Boro Zone | 0 |
| 4 | Alphabet City | 4 | Yellow Zone | 0 |
| 5 | Arden Heights | 5 | Boro Zone | 0 |
| 6 | Arrochar/Fort Wadsworth | 5 | Boro Zone | 0 |
- zone_idnumber · unique id
- 1
- zone_nametext
- Newark Airport
- borough_idnumber · links to boroughs
- 1
- service_zonetext
- EWR
- is_airportnumber
- 1
- zone_idnumber · unique id
- 2
- zone_nametext
- Jamaica Bay
- borough_idnumber · links to boroughs
- 2
- service_zonetext
- Boro Zone
- is_airportnumber
- 0
- zone_idnumber · unique id
- 3
- zone_nametext
- Allerton/Pelham Gardens
- borough_idnumber · links to boroughs
- 3
- service_zonetext
- Boro Zone
- is_airportnumber
- 0
- zone_idnumber · unique id
- 4
- zone_nametext
- Alphabet City
- borough_idnumber · links to boroughs
- 4
- service_zonetext
- Yellow Zone
- is_airportnumber
- 0
- zone_idnumber · unique id
- 5
- zone_nametext
- Arden Heights
- borough_idnumber · links to boroughs
- 5
- service_zonetext
- Boro Zone
- is_airportnumber
- 0
- zone_idnumber · unique id
- 6
- zone_nametext
- Arrochar/Fort Wadsworth
- borough_idnumber · links to boroughs
- 5
- service_zonetext
- Boro Zone
- is_airportnumber
- 0
first 6 of 265 rows · your queries use all of them
solution.sql
Hints and the answer are always available. Using them counts the question as solved with help.