SourCaPlacement OS
Targeted Campus Assessment Prep
Loading SourCa...
Synchronizing placement benchmarks & campus recruitment roadmaps
Targeted Campus Assessment Prep
Loading SourCa...
Synchronizing placement benchmarks & campus recruitment roadmaps
Targeted Campus Assessment Prep
Setting up coding workspace...
Loading problem statement, test cases, and compiler sandbox
| id (int) | client_id (int) | driver_id (int) | city_id (int) | status (varchar) | request_at (date) |
|---|---|---|---|---|---|
| 1 | 1 | 10 | 1 | completed | 2013-10-01 |
| 2 | 2 | 11 | 1 | cancelled_by_driver | 2013-10-01 |
| 3 | 3 | 12 | 6 | completed | 2013-10-01 |
| 4 | 4 | 13 | 6 | cancelled_by_client | 2013-10-01 |
| 5 | 1 | 10 | 1 | completed | 2013-10-02 |
| 6 | 2 | 11 | 6 | completed | 2013-10-02 |
| 7 | 3 | 12 | 6 | completed | 2013-10-02 |
| 8 | 2 | 12 | 12 | completed | 2013-10-03 |
| 9 | 3 | 10 | 12 | completed | 2013-10-03 |
| 10 | 4 | 13 | 12 | cancelled_by_driver | 2013-10-03 |
| users_id (int) | banned (varchar) | role (varchar) |
|---|---|---|
| 1 | No | client |
| 2 | Yes | client |
| 3 | No | client |
| 4 | No | client |
| 10 | No | driver |
| 11 | No | driver |
| 12 | No | driver |
| 13 | No | driver |
Click 'Run & Verify Query' to test your SQL against the sample test fixture.