Рет қаралды 85
se keywords like "SQL tutorial," "CTE in SQL," "SQL queries," "SQL average function," etc.
#sqltutorial #ctes #sqlquiz #sql #sqltraining #sqlinterviewquestions
Hi, this is Rajanikanth Gaja and I post videos on Computer Science related concepts, especially data-related technologies, these videos will help you in interviews as well as in clearing your theory and coding questions. If this channel helped you even a bit, please consider subscribing to the channel.
If you need any personal help in SQL, Mock interviews, or Coding help You can contact me at rajanikanthgaja@gmail.com, Please note it will be charged.
Thank you :)
✨ Work-related E- emails can be sent to: rajanikanthgaja@gmail.com
CREATE TABLE orders (
order_id INT PRIMARY KEY,
order_date DATE,
customer_name VARCHAR(50),
sales INT
);
--------------------------------------------------------
INSERT INTO orders (order_id, order_date, customer_name, sales) VALUES
(1, '2023-01-01', 'Alexa', 1239),
(2, '2023-01-02', 'Alexa', 1239),
(3, '2023-01-03', 'Alexa', 1239),
(4, '2023-01-03', 'Alexa', 1239),
(5, '2023-01-01', 'Ramesh', 1239),
(6, '2023-01-02', 'Ramesh', 1239),
(7, '2023-01-03', 'Ramesh', 1239),
(8, '2023-01-03', 'Neha', 1200),
(9, '2023-01-03', 'Subhash', 100),
(10, '2023-01-03', 'Subhash', 230);