3 - Premium Customers (**Master SQL CTEs: Calculate Average Orders and More!**)

  Рет қаралды 85

Data Info @Rajanikanth Gaja

Data Info @Rajanikanth Gaja

10 күн бұрын

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

Пікірлер: 3
@Tejasri15150
@Tejasri15150 9 күн бұрын
@rajkumarpanigrahi2013
@rajkumarpanigrahi2013 3 күн бұрын
Your all videos sound is very bad please little bit increase the sound
@rajanikanthgaja2916
@rajanikanthgaja2916 Күн бұрын
Please check the latest video and give overall feedback not only about 🔊
4. SQL Query for LinkedIn Top Voice Badge #sqltutorial
11:50
Data Info @Rajanikanth Gaja
Рет қаралды 30
2."SQL Tutorial: Find Top Employee of the Month!"  #sql #sqltutorial
15:50
Data Info @Rajanikanth Gaja
Рет қаралды 207
ИРИНА КАЙРАТОВНА - АЙДАХАР (БЕКА) [MV]
02:51
ГОСТ ENTERTAINMENT
Рет қаралды 4,7 МЛН
THEY WANTED TO TAKE ALL HIS GOODIES 🍫🥤🍟😂
00:17
OKUNJATA
Рет қаралды 3,6 МЛН
A pack of chips with a surprise 🤣😍❤️ #demariki
00:14
Demariki
Рет қаралды 53 МЛН
Case 15 : Complex SQL Query 1 | Derive Points table for ICC tournament #sql
14:00
Data Info @Rajanikanth Gaja
Рет қаралды 326
SQL performance tuning and query optimization using execution plan
49:23
Angular Signals: What? Why? and How?
27:08
Deborah Kurata
Рет қаралды 53 М.
Build an SQL Agent with Llama 3 | Langchain | Ollama
20:28
TheAILearner
Рет қаралды 2 М.
💅🏻Айфон vs Андроид🤮
0:20
Бутылочка
Рет қаралды 729 М.
iOS 18 vs Samsung, Xiaomi,Tecno, Android
0:54
AndroHack
Рет қаралды 88 М.