Скачать
SQL Amazon Interview
Автор: Vijay Pratap
Загружено: 2025-06-28
Просмотров: 303
Описание:
--IDENTIFY PRODUCTS THT HAVE BEEN SOLD BUT HAVE NO RECORD IN THE PRODUCTS TABLE AND ALSO CALCULATE HOW MANY TIME EACH MISSING PRODUCT HAVE BEEN SOLD
CREATE TABLE PRODUCTS (
PRODUCT_ID INT PRIMARY KEY,
PRODUCT_NAME VARCHAR(100)
);
INSERT INTO PRODUCTS (PRODUCT_ID, PRODUCT_NAME)
VALUES
(101, 'Laptop'),
(102, 'Mobile'),
(103, 'Tablet');
CREATE TABLE SALES (
PRODUCT_ID INT
);
INSERT INTO SALES (PRODUCT_ID)
VALUES
(101),(101),(104),(104),(104),(105),(102),(106);
select * from PRODUCTS;
select * from SALES;
Доступные форматы для скачивания:
Скачать видео mp4
-
Информация по загрузке:
