Most-Asked SQL Window Function Interview Question (Zomato/DataLemur) Answered! #sql #viralvideo

Problem : https://datalemur.com/questions/sql-swapped-food-delivery

/* ===== 1. Table definition ===== */
CREATE TABLE orders (
order_id INTEGER CONSTRAINT orders_pk PRIMARY KEY,
item VARCHAR2(100)
);

/* ===== 2. Sample data ===== */
INSERT INTO orders (order_id, item) VALUES (1, 'Chow Mein');
INSERT INTO orders (order_id, item) VALUES (2, 'Pizza');
INSERT INTO orders (order_id, item) VALUES (3, 'Pad Thai');
INSERT INTO orders (order_id, item) VALUES (4, 'Butter Chicken');
INSERT INTO orders (order_id, item) VALUES (5, 'Eggrolls');
INSERT INTO orders (order_id, item) VALUES (6, 'Burger');
INSERT INTO orders (order_id, item) VALUES (7, 'Tandoori Chicken');

COMMIT;
Oracle
-----------------------------
with even_order as
(
select rownum as SEQ ,ORDER_ID,ITEM from orders where mod(order_id,2) = 0
) , odd_order as
(
select rownum as SEQ ,ORDER_ID,ITEM from orders where mod(order_id,2) != 0
) , first_data as
(
select item, rownum as order_id from (select item from (select
e.ITEM as item,e.order_id as ord ,rownum as s
from even_order e join odd_order o on e.SEQ = o.SEQ
union
select
o.ITEM as item,o.order_id as ord ,rownum as s
from even_order e join odd_order o on e.SEQ = o.SEQ) order by s,ord desc
)
)
select order_id,item from (select item,order_id from first_data
union
select item,order_id from orders where item not in (select item from first_data) order by ORDER_ID
)

faang interview, sql questions asked in interview, everyday data science, data science interview questions, day in life of data analyst, data science, datalemur, linkedin data analyst, linkedin data science interview, linkedin data science profile, how to solve data science problems, how to solve data science case study, sql interview questions, sql solutions, learn sql in 1 hour, eds, data, personal finance, stocks to buy now, tiktok viral, failing bank, faang pay, stripe

#SQL #DataLemur #SQLInterviewQuestions #DataAnalytics #PizzaProblem #SQLJoins #LearnSQL #TechInterviewPrep
faang interview,sql questions asked in interview,everyday data science,data science interview questions,day in life of data analyst,data science,datalemur,linkedin data analyst,linkedin data science interview,linkedin data science profile,how to solve data science problems,how to solve data science case study,sql interview questions,sql solutions,learn sql in 1 hour,eds,data,personal finance,stocks to buy now,tiktok viral,failing bank,faang pay,stripe

Видео Most-Asked SQL Window Function Interview Question (Zomato/DataLemur) Answered! #sql #viralvideo канала vikas_vooradi