deloitte interview question in sql | sql interview questions | #interview | #sql |#data

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 : https://www.youtube.com/watch?v=aHRy8mTzxNs Need Help ? Connect With me 1:1 - https://topmate.io/dewithdhairy Let's connect on LinkedIn : https://www.linkedin.com/in/dhirajgupta141/ PySpark Installation and Setup : https://youtu.be/jO9wZGEsPRo?si=WVktJl4eh0mN3P9X DSA In Python Interview Series : https://youtube.com/playlist?list=PLqGLh1jt697wQTamFvXx_Odlm-Wg3zbxq&si=CAiVdcY4A7CEOKlO PySpark Interview Series : https://youtube.com/playlist?list=PLqGLh1jt697zXpQy8WyyDr194qoCLNg_0&si=-JG6S1LyZzjDZyPB Pandas Interview Series : https://youtube.com/playlist?list=PLqGLh1jt697yabH8-hRdV8Y5nzIEHDo29&si=1bwfHNeKLvcUFFXX SQL Interview Series : https://youtube.com/playlist?list=PLqGLh1jt697xtgiGwGUTFpOctT82ANdJZ&si=fsF6PkJiStf9_Dh- #deloitte #sql #interview #dataengineers #dataanalytics #datascience #StrataScratch #Facebook #data #dataengineeringinterview #codechallenge #datascientist #pyspark #CodingInterview #dsafordataguy