Lec-67: SQL Aggregate Functions - SUM, AVG(n), COUNT, MIN, MAX Functions | DBMS

👉Subscribe to our new channel: / @varunainashots
0:00 - Introduction
1:16 - MAX
3:25 - MIN
4:20 - COUNT
6:52 - SUM
8:13 - AVG
► Structured Query Language (SQL)(Complete Playlist):
• Structured Query Langu...
Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
• Design and Analysis of...
►Computer Architecture (Complete Playlist):
• Computer Organization ...
► Theory of Computation
• TOC(Theory of Computat...
►Artificial Intelligence:
• Artificial Intelligenc...
►Computer Networks (Complete Playlist):
• Computer Networks (Com...
►Operating System:
• Operating System (Comp...
►Database Management System(Complete Playlist):
• DBMS (Database Managem...
►Discrete Mathematics:
• Discrete Mathematics
►Compiler Design:
• Compiler Design (Compl...
►Number System:
• Number system
►Cloud Computing & BIG Data:
• Cloud Computing & BIG ...
►Software Engineering:
• Software Engineering
►Data Structure:
• Data Structure
►Graph Theory:
• Graph Theory
►Programming in C:
• C Programming
►Digital Logic:
• Digital Logic (Complet...
---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
► Subscribe to us on RUclips: / gatesmashers
►Subscribe to our new channel: / @varunainashots
► Like our page on Facebook: / gatesmashers
► Follow us on Instagram: / gate.smashers
► Follow us on Instagram: / varunainashots
► Follow us on Telegram: t.me/gatesmashersofficial
► Follow us on Threads: www.threads.net/@gate.smashers
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:
Email us at: [e-mail]

[@deepikajuneja2113]

Great video! Kudos to you, sir!
Just a few corrections though:
1. Instead of SELECT DISTINCT(COUNT Salary) FROM Emp; , the query should be SELECT COUNT(DISTINCT Salary) FROM Emp;
2. Similarly, instead of SELECT DISTINCT(SUM Salary) FROM Emp; , the query should be SELECT SUM(DISTINCT Salary) FROM Emp; , and
3. Instead of SELECT DISTINCT(AVG Salary) FROM Emp; , the query should be SELECT AVG(DISTINCT Salary) FROM Emp;

[@sudhanshukumar3391]

Yeah I also able to figured it out as I was doing practical side by side

[@dushyantrayakwar1208]

thnx ,

[@thandepaji]

true

[@siddhantramgir8118]

yeah faced the same thing while practicing and was about to comment the same

[@Dk32285]

Thanks for sharing

[@aaryangarhewal]

6:40 SELECT COUNT( DISTINCT Salary) FROM Emp; is the correct answer.

[@fullygaming3647]

ooh bro thanks i was also confused when it didnt worked

[@hammadaftab618]

One of the best RUclips channels for engineering and computer science students.👌👌

[@bipulkumar9254]

It was a great video to learn SQL, Between kindly correct your query expression at time 6:17 to SELECT COUNT(DISTINCT(salary)) FROM employee; Thank you.

[@janvinaik5072]

Thanks

[@mallikarjunpidaparthi]

@@janvinaik5072 hey it's good to see an army here

[@janvinaik5072]

@@mallikarjunpidaparthi ohh heyy!!!!!

[@janvinaik5072]

@@mallikarjunpidaparthi army??

[@mallikarjunpidaparthi]

@@janvinaik5072 yes I am

[@eshas3930]

I came across ur videos. And I swear u made my life easier. I wanted to join SQL classes, however couldn't join right now due to financial condition.. And I started following ur videos. I don think I need any coaching outside. Thanks sir.

[@syedziauddin2923]

You're right bro

[@Believers_c.c]

Trueee..,😍

[@SahirJafri]

Thank you so much for all your hard work!!! We really appreciate it!!

[@rahulkushwaha8933]

select sum ( distinct ( salary ) ) from emp;
cos first we have to distinct the data and then we want the sum of that distinct data.

[@GAUTAMKUMAR-or7rh]

Yes I have same problem with that....
We need to distinct salary then take sum.

[@rameshmalhotra9525]

ruclips.net/video/5FsIa4Mp3ho/видео.html

[@souravmahanty7615]

good bro....I also face the same problem and bcz of u it solve

[@merafunpoint7864]

i really appreciate ur videos. They helped me alot in clearing my concepts thanks for such good stuff

[@shellnetpeak9466]

One question but the answer providing with complete details , that's superb. Thank you so much sir

[@shrikant301991]

You are a great teacher...much appreciated...thanks...no technical background required to understand your explanation..

[@varunsonavne3344]

Sir you deserve to be a best youtuber according to me you explaining topic very easily

[@atulraj816]

It was a great video to learn SQL, But in this video kindly correct your query expression at time 6:17 to SELECT COUNT(DISTINCT(salary)) FROM employee;

[@deepikareddy1073]

I watch all of your videos and you are a saviour! You make us understand complex concepts in easier way,thanks a ton! I recommend your channel to my friends and they love it too:)

[@satyamtiwari4917]

Bhai maza aa gaya aapse padh kr. sab log bhai ka channel subscribe kro aur bell dabana na bhulna🙏🙏🙏

[@shetkari8465]

Respected sir... You are really great...getting the concept clearly

[@ghulammahdi6702]

I got Alpha in OS by understanding concepts from videos of sir now I am studying DBMS and now I again came back to sir lectures

[@ElecPrizyy]

Thank you so much sir, this video really helped me understand aggregate functions!

[@universeboss4865]

Sir ji query thori glt likh di apne
Select COUNT(DISTINCT salary) from emp order by asc;

[@jameskamgar]

select count(distinct(dept)) from emp;
This is the correct one thanks

[@girishbabu2697]

Excellent explanation sir.... Love ur videos

[@nivedithanataraj8985]

Thank you..sooo much sir
Excellent teaching

[@supriya5588]

Thank you so much for all your videos. It is easy to understand

[@alfiemcmillan262]

Couldn’t get my head around this in classes thanks for your help

[@riya3947]

Sir, you are the best. Your videos helped me a lot. Thank you

[@sadafnoori2420]

Thank you so much . Ur videos helped me a lot

[@abuzarakhoni6254]

Thank you sir for teaching us and keep going

[@ankitashahane1833]

select sum(distinct(salary) )from emp; will actually give sum of distinct salaries.

[@ShivamSharma-cq7ws]

PADHAKU BACCHE 🙃

[@adarshchourasiya4924]

Thanks you, sir aap bhaut he aaram aaram se samjhte ho to sab ek baar me samaj a jata h.... Again thank you!!

[@vikichhaya7824]

Detailed explanation. Thank you.

[@ayeshabutt7682]

thank you sir for make this easy video for us

[@md.arifmehedi6559]

So nice ,
This tutorial beneficiate me more detailing...
thanks dear

[@GaganDeep-mj5hi]

Sir aap logic ko bahut hi acche sai samjhate ho. Great job.

[@nnsalaria2851]

You way of teaching is outstanding sir😊

[@Imrajeshsandhuvlogs]

it was a great person and each in every ponit.

[@gopalchaudhary6170]

Thank you so much sir Bahut hi achhi series hai ❤️🙏

[@SHREE_RAM__]

Bro kuch bhi hai pr aapne har ek aggregate ko har tarh ki situation se bta hai thanku bro ❤️

[@kp_nagar]

i think correct syntax is -.> SELECT count (DISTINCT salary) FROM emp; thanks for videos sir

[@chankitsharma5535]

yes bro you are right

[@sharmilakhanal7849]

Thank you so much sir for making these videos🙏🙏🙏🙏

[@Kalpana_16]

U r perfect trainer 👍thank u

[@shivtejdande7156]

Very Very Nice Teaching Sir ,thank you so much.

[@inshkakar]

thanks alot for this information🥰.......today is my assignmnt and i get hlp from this video

[@KPS_Digital]

Sir you are Great , Excellent explanation

[@pournimabhuyar5827]

Thanks a lot sir for such a understansting teaching 😊

[@shabashvalishaik6568]

thank you so much sir excellent teaching...
i

[@samyakshah9119]

Thank you bhaiya for this amazing explanation!

[@sajansekhu8785]

thnkk u so much sir..i m the biggest fan of u ...really..

[@saiyedhussain3678]

really so helpful ...thank sir.

[@brightbrainpuzzles]

You are the best teacher in my life.

[@shariqueshan]

Thanks, helpfull video

[@rhythmtomar7872]

Sir ne employee table me apni salary sabse zada likhi h 🤣🤣🤭🤭🤭

[@pavankulkarni7431]

Salary is in dollars

[@rhythmtomar7872]

@@pavankulkarni7431 I don't bro 😅

[@rameshmalhotra9525]

ruclips.net/video/5FsIa4Mp3ho/видео.html

[@rahultilwani6813]

Rahul Kushwaha
1 year ago
select sum ( distinct ( salary ) ) from emp;
cos first we have to distinct the data and then we want the sum of that distinct data.
9

[@akshitakatiyar8170]

Very nice, km time m jyada fayda🙏 I like uhhh

[@animationcrust1993]

When I start watching your videos ...I automatically continued to watch one by one 😂😊

[@papumoharana3981]

Thank u so much sir.

[@sujitchavan5899]

thank u so much Bro , Gr8 eforts for us

[@Sahilverma-br1kl]

All of ur videos are easily understandable ... Punjabi's are lit

[@problemssolver995]

Lots of love hats off sir

[@venkatasairamguddeti8957]

Simply super bro TQs

[@sivamkumar6168]

Thanks you sir for this video.. Tomorrow is my presentation in our class... And your video is very helpfull really2 thanks sir..

[@shubhamgophane5414]

Thanks for the easy explanation🙂

[@AnshulPatle31]

Now I will definitely score well in university exam. Thanks sir

[@swapnamishra9796]

Super se bahut uper sir ..thanks alot ...

[@subhassindhe7241]

Super bro Ur teaching

[@pamartyhimaja6315]

Thanks a lot...... It really helped me😊

[@tejasasaldekar9674]

You are so hardworking
Keep it up

[@Sahilverma-br1kl]

Thanku sir for making this topic so clr

[@adnanabrar7121]

Wow tusi great ho sir bohat acha andaz Hy parhanay ka keep going bro

[@GateSmashers]

Thank You. Keep learning and sharing

[@sayali8726]

Hello Sir , Your videos are too good . Please make videos on sql network traffic

[@ananyapanwar9217]

Thanku😊😊😊😊😊😊

[@amandeep-op2up]

Thnku so much sir this video is very helpful for me 🙏🙏🙏

[@devendradeepak4113]

You will always remain in my youtube subscribed list.

[@garimalove4everything]

Sir..we love ur videos..if possible plz go through the syllabus of NVS PGT computer science syllabus..nd teach according to their syllabus till the NVS exam..plzzz it's a request sir..unka syllabus dekhne m hi bht dangerous hai

[@Vanaja.Arigala]

Thank you so much clear understand

[@futurehousemusic7080]

Thank you sir you are awesome

[@shreyasmanishbhosale1418]

great work sir...!

[@chaitanyahajare5915]

Great content, no doubt on that! !! but the only problem I usually face is that videos are not in sequence in playlist, in this playlist also after Lec -50 there is direct Lec-55 andI couldn't find Lec-51 in this playlist. This is the same reason I left in between the 'Computer Organization' series..

[@arvindchauhan2834]

Yes this is my problem also

[@nehanoor2119]

Sir u r great God bless u inshaAllah

[@vaibhavwani1065]

Tank you!!

[@rehanarain9242]

It is such a nice way helpfull

[@sankalparora9261]

Great video. It's like learning SQL in the easiest way possible. It is only possible by a great Teacher like Singla Sir. Thank you, sir.

[@graphic_designer35]

JAZAK Allah sir

[@reshmaramesh3259]

Great sirrrrr very helpfull

[@ShirishaBethi]

Nice explanation 👍

[@izharkhankhattak]

Very Nice, Man!

[@elliaisaac9039]

Well Explained.

[@muskan-co5yn]

U r genius sir actually 👍👍👍👍👍👍👍👌👌👌👌👌👌

[@studyrj404]

Thank you sir

[@omkarmali2663]

Channal deserves 1M

[@poonamgautam6495]

thanks sir....

[@pranjalgupta9427]

Thanks❤

[@mramilutamroy6370]

Thanks brother, From Bangladesh ❤❤😊

[@Dynamic.programing]

Nice sir bhut easy way mai smjha diye

[@chanchalnishad3]

Thankyouu so much sir😇

[@namratanikam7566]

Very well explained😊😊👌

[@chanchalgupta4837]

Thnq uu soo much sr

[@Gulam725]

superb teaching sir ji

[@user-ey3di9se6i]

Sir thank you for helping student ❤❤❤

[@ZohaibRajpootFromSheikhupura]

Love from Pakistan 🇵🇰❤️
Great work sir 😊

[@babulaljangir8275]

thank u....

[@divyaagarwal3563]

Thankyou sir