Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
1. Trips and Users
On this page

Problem

Table: Trips

+-------------+----------+
| Column Name | Type     |
+-------------+----------+
| id          | int      |
| client_id   | int      |
| driver_id   | int      |
| city_id     | int      |
| status      | enum     |
| request_at  | date     |     
+-------------+----------+
id is the primary key (column with unique values) for this table.
The table holds all taxi trips. Each trip has a unique id, while client_id and driver_id are foreign keys to the users_id at the Users table.

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page