INFOSYS SQL INTERVIEW QUESTION | Seats Vacancies

Описание: Join this channel to get access to perks:
   / @datasculptor2895  

Feedback: https://forms.gle/NQuCAy7p5a9wxW3LA

DROP TABLE IF EXISTS Journey;

CREATE TABLE Journey
(
[Name] varchar(100),
[Start] varchar(10),
[End] varchar(10)
)


INSERT INTO Journey
VALUES
('Alice','A','D'),
('Bob','B','D'),
('Charlie','C','D'),
('David','A','C'),
('John','B','E'),
('Kevin','C','E')

DROP TABLE IF EXISTS Trip;

CREATE TABLE Trip
(
[Order] INT,
[City] varchar(10)
)

INSERT INTO Trip
VALUES
(1,'A'),
(2,'B'),
(3,'C'),
(4,'D'),
(5,'E')



SELECT * FROM [Journey]
SELECT * FROM [Trip]


Playlists:
SQL Interview Questions:    • SQL Interview questions  
Recursive CTE:    • Recursive CTE  
PySpark Interview Questions:    • PySpark Interview Questions  
Power BI and DAX:    • Power BI and DAX  
Data Modeling:    • Data Modelling  
Generative AIs:    • Generative AIs  
Excel:    • Excel  
Cricket:    • Cricket  
SQL ADVANCED AGGREGATIONS:    • ADVANCED AGGREGATIONS SQL  



Follow me
Linkedin:   / data-sculptor-93a00b2a8  
Instagram:   / datasculptor2895