Welcome to my channel! I'm Raghav Bakshi, a seasoned Business Analyst with a passion for transforming data into actionable insights. With experience at leading Indian tech startups like Swiggy, Meesho, and MathCo, l've navigated the dynamic landscape of the industry, transitioning from a nontechnical background to a technical role after completing my Master's in Economics.
If you want me to solve any question, do share your questions at [email protected]
Connect on Social media:
LinkedIn: https://www.linkedin.com/in/raghavbakshi19/
Instagram: https://www.instagram.com/raghav.decodes/
Book 1:1 on Topmate: https://topmate.io/raghav_bakshi
Linktree: https://linktr.ee/Raghavbakshi
CREATE DATABASE IF NOT EXISTS order_analytics;
USE order_analytics;
drop table orders;
CREATE TABLE orders (
order_id INT,
customer_id INT,
order_date DATE
);
INSERT INTO orders (order_id, customer_id, order_date) VALUES
(1, 101, '2024-01-01'),
(2, 102, '2024-01-01'),
(3, 103, '2024-01-02'),
(4, 104, '2024-01-03'),
(5, 105, '2024-01-04'),
(6, 106, '2024-01-04'),
(7, 107, '2024-01-05'),
(8, 108, '2024-01-05'),
(9, 109, '2024-01-06'),
(10, 110, '2024-01-07'),
(11, 111, '2024-01-08'),
(12, 112, '2024-01-08'),
(13, 113, '2024-01-08'),
(14, 114, '2024-01-09'),
(15, 115, '2024-01-09'),
(16, 116, '2024-01-10');
#sql #interview #interviewquestions #sqlforbeginners #joins #innerjoin #leftjoin #rightjoin #sqlbasics #mysql #raghavdecodes #swiggy #swiggyinterview #dataanalyst #businessanalyst #mysql
