Write a SQL query to find the most common path to a test-drive booking.
Use test_drive_bookings and session_events. A path consists of the ordered non-null events in a session associated with a booking.
path and booking_count.| Column | Type | Description |
|---|---|---|
| booking_idPK | INT | Unique test-drive booking identifier |
| session_id | VARCHAR(50) | Web session associated with the booking |
| booking_date | DATE | Date on which the booking was created |
| Column | Type | Description |
|---|---|---|
| event_idPK | INT | Unique session event identifier |
| session_id | VARCHAR(50) | Web session that generated the event |
| event_order | INT | Sequence position of the event within the session |
| event_name | VARCHAR(100) | Name of the customer journey event |