SQL Amazon Interview

--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;

Видео SQL Amazon Interview канала Vijay Pratap