SQL Challenges #10: Journey Mapping- Tracing Origins to Destinations

In this video, we will analyze journey mapping, offering insights into destinations from their origins.

SQL Challenge 9:- https://youtu.be/lMpGKBbovzI

Solve SQL Challenges Playlist:- https://www.youtube.com/playlist?list=PLP1_hACWUYHyUapnM-HgBOm7ACgW15Cm6

SQL Tutorial- https://www.youtube.com/playlist?list=PLP1_hACWUYHyOSe2-UFShVp-zSVoc9qLs

SQL Interview Questions Playlist- https://www.youtube.com/playlist?list=PLP1_hACWUYHz8iEKxsu69ig7hv_Wfon2M

DDL & DML Script:-

DROP TABLE IF EXISTS travels
CREATE TABLE travels
(
id VARCHAR(512),
tid VARCHAR(512),
origin VARCHAR(512),
destination VARCHAR(512)
);

INSERT INTO travels (id, tid, origin, destination) VALUES ('1', 't1', 'New York', 'Los Angeles');
INSERT INTO travels (id, tid, origin, destination) VALUES ('1', 't2', 'Los Angeles', 'San Francisco');
INSERT INTO travels (id, tid, origin, destination) VALUES ('2', 't4', 'Chicago', 'Houston');
INSERT INTO travels (id, tid, origin, destination) VALUES ('2', 't5', 'Houston', 'Miami');
INSERT INTO travels (id, tid, origin, destination) VALUES ('3', 't7', 'London', 'Paris');
INSERT INTO travels (id, tid, origin, destination) VALUES ('3', 't8', 'Paris', 'Rome');

SELECT * FROM travels

Видео SQL Challenges #10: Journey Mapping- Tracing Origins to Destinations канала Mohit Singh