deloitte interview question in sql | sql interview questions |

deloitte interview question in sql | sql interview questions | #interview | #sql |#data
In this video we will be solving DELOITTE interview question in SQL.
Create Table Statement :
========================
CREATE TABLE products (
product_id INT PRIMARY KEY,
product_name VARCHAR(50),
category VARCHAR(50)
);
INSERT INTO products (product_id, product_name, category) VALUES
(1, 'Laptops', 'Electronics'),
(2, 'Jeans', 'Clothing'),
(3, 'Chairs', 'Home Appliances');
CREATE TABLE sales (
product_id INT,
year INT,
total_sales_revenue DECIMAL(10, 2),
PRIMARY KEY (product_id, year),
FOREIGN KEY (product_id) REFERENCES products(product_id)
);
INSERT INTO sales (product_id, year, total_sales_revenue) VALUES
(1, 2019, 1000.00),
(1, 2020, 1200.00),
(1, 2021, 1100.00),
(2, 2019, 500.00),
(2, 2020, 600.00),
(2, 2021, 900.00),
(3, 2019, 300.00),
(3, 2020, 450.00),
(3, 2021, 400.00);
PySpark Step by Step Approach and Solution explanation video for this problem : • deloitte interview que...
Need Help ? Connect With me 1:1 - topmate.io/dewithdhairy
Let's connect on LinkedIn : / dhirajgupta141
PySpark Installation and Setup : • Spark Installation | P...
DSA In Python Interview Series : • dsa for data engineer ...
PySpark Interview Series : • pyspark interview ques...
Pandas Interview Series : • pandas interview quest...
SQL Interview Series : • sql interview question...
#deloitte #sql #interview #dataengineers #dataanalytics #datascience #StrataScratch #Facebook #data #dataengineeringinterview #codechallenge #datascientist #pyspark #CodingInterview
#dsafordataguy

[@rajeshraxz9571]

Your explantion and questions are very good ..
We want this type of interview questions and crack the very easy for interview.

[@DEwithDhairy]

Thanks for your kind word...
Do share the channel it will help in growing this channel.
Thanks.

[@rajeshraxz9571]

@@DEwithDhairy sure definitely

[@mohammadsalik468]

Thanks for the explanation
By the way where are you getting the interview questions?

[@DEwithDhairy]

Thanks
Found on the LinkedIn only