Загрузка...

SQL Interview Question | BookMyShow | Series 05

If you like this video please
like share , subscribe and comment down below..
if you have any suggestion or doubt this video..

Scripts:

CREATE TABLE [cinema](
[seat_id] [int] NOT NULL,
[free] [int] NULL,
)

INSERT INTO [cinema] ([seat_id], [free]) VALUES (1, 1)
INSERT INTO [cinema] ([seat_id], [free]) VALUES (2, 0)
INSERT INTO [cinema] ([seat_id], [free]) VALUES (3, 1)
INSERT INTO [cinema] ([seat_id], [free]) VALUES (4, 1)
INSERT INTO [cinema] ([seat_id], [free]) VALUES (5, 1)
INSERT INTO [cinema] ([seat_id], [free]) VALUES (6, 0)
INSERT INTO [cinema] ([seat_id], [free]) VALUES (7, 1)
INSERT INTO [cinema] ([seat_id], [free]) VALUES (8, 1)
INSERT INTO [cinema] ([seat_id], [free]) VALUES (9, 0)
INSERT INTO [cinema] ([seat_id], [free]) VALUES (10, 1)
INSERT INTO [cinema] ([seat_id], [free]) VALUES (11, 0)
INSERT INTO [cinema] ([seat_id], [free]) VALUES (12, 1)
INSERT INTO [cinema] ([seat_id], [free]) VALUES (13, 0)
INSERT INTO [cinema] ([seat_id], [free]) VALUES (14, 1)
INSERT INTO [cinema] ([seat_id], [free]) VALUES (15, 1)
INSERT INTO [cinema] ([seat_id], [free]) VALUES (16, 0)
INSERT INTO [cinema] ([seat_id], [free]) VALUES (17, 1)
INSERT INTO [cinema] ([seat_id], [free]) VALUES (18, 1)
INSERT INTO [cinema] ([seat_id], [free]) VALUES (19, 1)
INSERT INTO [cinema] ([seat_id], [free]) VALUES (20, 1)
#coding
#sqlqueryinterviewquestionsandanswers
#sql
#sqlserver
#oraclesql
#mysql
#postgresql

Видео SQL Interview Question | BookMyShow | Series 05 канала Coding Lake
Страницу в закладки Мои закладки
Все заметки Новая заметка Страницу в заметки

На информационно-развлекательном портале SALDA.WS применяются cookie-файлы. Нажимая кнопку Принять, вы подтверждаете свое согласие на их использование.

Об использовании CookiesПринять