Aggregate Function, group by, having clause in SQL | Informatics Practices Class 12 | Lovejeet Arora
Вставка
- Опубліковано 29 жов 2024
- In this video, Lovejeet Arora, your educator for Class 12 will be conducting a session on Aggregate Function, group by, having clause in SQL, Informatics Practices on the Unacademy CBSE Commerce 11 & 12. Unacademy aims at paving a strong foundation for students. Stay tuned for more!
✅Subscribe to Unacademy CBSE Commerce 11 & 12: unacademy.onel...
✅ Follow Lovejeet Arora on Unacademy Learning App: unacademy.onel...
✅ Watch Upcoming FREE Special Class by Lovejeet Arora on Unacademy App
Class 11: unacademy.onel...
Class 12: unacademy.onel...
Use Code LALIVE To Unlock
✅For Unacademy Class 11 Subscription, click here NOW: unacademy.onel...
✅For Unacademy Class 12 Subscription, click here NOW: unacademy.onel...
Use Referral Code LALIVE to get a 10% DISCOUNT on your Unacademy Subscription
✅ Download the Unacademy Learning App:
👉🏼 Android: play.google.co...
👉🏼 iOS: apps.apple.com...
✅ How to Install Unacademy Learning App 🤔
Here's the Step by Step Guide to download the App -
Step 1: Search for 'Unacademy Learning App' on iOS/Google Playstore.
Step 2: Install the App & Click on the Open
Step 3: Click on 'Get Started'
Step 4: Click on Register & Enter your Phone Number
About Educator: Lovejeet Ma’am is a Passionate Programmer & has more than 3 years of teaching experience.
✅Follow Unacademy CBSE Commerce 11 & 12 on telegram: t.me/Unacademy...
✅Follow Lovejeet Arora on telegram:
Class 11- t.me/TECHQueen...
Class 12- t.me/TECHQueen...
----------------------------------------------------------------------------------------------
✅ Our Website - unacademy.onel...
----------------------------------------------------------------------------------------------
Apart from the UA-cam channel, you can also subscribe to Unacademy Plus and get the following benefits:
1. Learn from your favorite educators
2. Dedicated DOUBT sessions
3. One Subscription, Unlimited Access to Live Online Classes and Videos
4. Real-time interaction with best-in-class educators
5. You can ask doubts in live online classes
6. Download the videos & watch them offline
7. NCERT Solutions
#cbse #s #cbse term2 #commerce
9:35 the class starts
Thanks ❤️
Tqq
Thank you dude
🤣
Select Job, AVG(BONUS) from Empdata group by JOB;
Us
Ma'am You Explain so wonderful full...I given 5 star ⭐⭐⭐⭐⭐ for your explanation.... thanks You ma'am ❤❤❤
select job, avg(salary) as 'Average Salary' from empdata group by job;
maam ur illustrations are really commendable, u made the concepts so clear!!
Select job,avg(salary) from empdata group by job;
Select job, AVG (salary)
From employee
Group by job;
Select job avg(bonus) from empdata group by job
43:30 Select job , avg(Bonus) from empdata Group by job;
select job, avg(salary) from emp group by job; 45:40
Select Job,avg(Bonus) from Empdata group by Job;
Select job, avg(bonus) from empdata group by job;
Class start from 9:35
select job,avg(bonus) from empdata group by job;
select job, AVG(bonus)
FROM empdata
GROUP BY job;
select job ; Avg(salary) from empdata group by job;
Select job, AVG(bonus) from empdata group by job
Thank ma'am for helping Mee ❤❤
Select job avg(bonus) from empdata group by Job;
Select job, Avg(bonus) from empdate groupby job;
Select job,avg(bonus)From empdata group by job
Tqsm maam ❤️✨,now I have no problem in aggregate functions 😘❣️
Hii Taniya🤘
From empdata group by bouns;
Select bonus, avg(bonus) ;
Q 5.
ans -> select job, avg(bonus) from empdata group by job;
Awesome!
Salute to your spirit!
hii deepti
Can anyone pls shre the questions here about Which mam mentioned in end???
Select job avg(bonus) from( erp )
Thank u mam
avg(bouns)from empdata group by job;
Mam I want the notes of this lecture kaise milenge mam ?
Great mam app great ho
SELECT JOB , AVG (BONUS) FROM EMPDATA GROUP BY JOB ;
Thank you so much mam
Select count (*)
Mam u r great ❤️👍
Thank you so much ❤️
9:35 starts
thank you 😊
Before preboard exam
Vinay
27:49
select avg(bonus) from emp group by job; 43:11
Empdata
Hi abhay
Ha batao
27:20 par jao
@@patelabhay550 okk
Padh liya
Societal impacts
Mem mujhe Class jine karni hi
Hlo
Hi
37:11 hum hai Faridabad se 😈😈
good sound quality...........🤣🤣
maam please speak a little louder
Ii
First 10 min is time waste
Select job, avg(bonus) from empdt group by job;
Select job, avg(bonus) from emp group by job
Select job avg(bonus) from empdata group by job;
select job,avg(bonus) from empdata group by job;
Select Job, avg(Bonus) from Empdata group by Job ;
select job,avg(salary) from empdata group by job;
Select avg(bonus),job from empdata group by job;
Select job,avg(bonus) from Empdata group by job;
Select job ,avg(bonus) from empdata group by job ;
Select job , avg(bonus) from empdata group by job ;