Aggregate Function, group by, having clause in SQL | Informatics Practices Class 12 | Lovejeet Arora

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

[@ayeshaimran1724]

9:35 the class starts

[@SohamChavan_0507]

Thanks ❤️

[@anshikachaturvedi6087]

Tqq

[@anmolkumari2290]

Thank you dude

[@mayuraggarwal7020]

🤣

[@vanshikagupta6478]

Select Job, AVG(BONUS) from Empdata group by JOB;

[@ritzcreations7947]

Us

[@_dpky_]

Ma'am You Explain so wonderful full...I given 5 star ⭐⭐⭐⭐⭐ for your explanation.... thanks You ma'am ❤❤❤

[@SumitSingh-hx4pe]

select job, avg(salary) as 'Average Salary' from empdata group by job;
maam ur illustrations are really commendable, u made the concepts so clear!!

[@nikitaarora2468]

Select job,avg(salary) from empdata group by job;

[@sanikanimje111]

Select job, AVG (salary)
From employee
Group by job;

[@mantashaahmed7132]

Select job avg(bonus) from empdata group by job

[@CREace18]

43:30 Select job , avg(Bonus) from empdata Group by job;

[@niravdevasi6704]

select job, avg(salary) from emp group by job; 45:40

[@deeptiyadav6406]

Select Job,avg(Bonus) from Empdata group by Job;

[@nikitaarora2468]

Select job, avg(bonus) from empdata group by job;

[@saba6836]

Class start from 9:35

[@shaileshjanbandhu3481]

select job,avg(bonus) from empdata group by job;

[@pragatisharma3525]

select job, AVG(bonus)
FROM empdata
GROUP BY job;

[@vanshikagupta6478]

select job ; Avg(salary) from empdata group by job;

[@Brownmunde1001]

Select job, AVG(bonus) from empdata group by job

[@anujpawar4881]

Thank ma'am for helping Mee ❤❤

[@saba6836]

Select job avg(bonus) from empdata group by Job;

[@GuptYash]

Select job, Avg(bonus) from empdate groupby job;

[@aseemshakya9616]

Select job,avg(bonus)From empdata group by job

[@taniyarai9862]

Tqsm maam ❤️✨,now I have no problem in aggregate functions 😘❣️

[@ankurdey7346]

Hii Taniya🤘

[@DANIEL-jx9jo]

From empdata group by bouns;
Select bonus, avg(bonus) ;

[@chiragnanda1990]

Q 5.
ans -> select job, avg(bonus) from empdata group by job;

[@deeptiyadav6406]

Awesome!
Salute to your spirit!

[@ankurdey7346]

hii deepti

[@prishakapoor1837]

Can anyone pls shre the questions here about Which mam mentioned in end???

[@kavyaofficial1356]

Select job avg(bonus) from( erp )

[@manishkmeena6376]

Thank u mam

[@dope_Nmean]

avg(bouns)from empdata group by job;

[@Mukeshsharma-wz9zx]

Mam I want the notes of this lecture kaise milenge mam ?

[@neerusrivastav607]

Great mam app great ho

[@shinchansings3329]

SELECT JOB , AVG (BONUS) FROM EMPDATA GROUP BY JOB ;

[@Blabla-bo6ze]

Thank you so much mam

[@Schooling.Education.ABC.]

Select count (*)

[@manojdubey283]

Mam u r great ❤️👍

[@ishasinha8205]

Thank you so much ❤️

[@priyatiwari1097]

9:35 starts

[@adityaprabhakar7368]

thank you 😊

[@patelabhay550]

Before preboard exam

[@patelabhay550]

Vinay

[@15_d]

27:49

[@niravdevasi6704]

select avg(bonus) from emp group by job; 43:11

[@Schooling.Education.ABC.]

Empdata

[@vinay-zu1vq]

Hi abhay

[@patelabhay550]

Ha batao

[@patelabhay550]

27:20 par jao

[@vinay-zu1vq]

@@patelabhay550 okk

[@patelabhay550]

Padh liya

[@patelabhay550]

Societal impacts

[@AnilKumar-rn1xg]

Mem mujhe Class jine karni hi

[@patelabhay550]

Hlo

[@vinay-zu1vq]

Hi

[@ritzcreations7947]

37:11 hum hai Faridabad se 😈😈

[@harshanjalsinghrajput5308]

good sound quality...........🤣🤣

[@arifsaifi6519]

maam please speak a little louder

[@fouziasheriff8959]

Ii

[@Businessbol]

First 10 min is time waste

[@g.mehraa]

Select job, avg(bonus) from empdt group by job;

[@Trueguider5304]

Select job, avg(bonus) from emp group by job

[@comotive762]

Select job avg(bonus) from empdata group by job;

[@jugnugupta6839]

select job,avg(bonus) from empdata group by job;

[@ronak7964]

Select Job, avg(Bonus) from Empdata group by Job ;

[@shaileshjanbandhu3481]

select job,avg(salary) from empdata group by job;

[@laxmiharit2232]

Select avg(bonus),job from empdata group by job;

[@sipradutta358]

Select job,avg(bonus) from Empdata group by job;

[@mohdadnan11thc73]

Select job ,avg(bonus) from empdata group by job ;

[@ishasinha8205]

Select job , avg(bonus) from empdata group by job ;