Watch our full video tutorial: SQL GROUP BY: Visual Guide & Examples π
https://dai.ly/x9l66pg
---
π» Get started with cloud or VPS hosting with DigitalOcean and receive a $200 credit for 60 days through our link π
https://watsontechworld.com/digitalocean
---
Our website: https://watsontechworld.com
---
#SQL #MySQL #GROUPBY #SQLTutorial #SQLGROUPBY #DataAnalysis #database #LearnSQL
https://dai.ly/x9l66pg
---
π» Get started with cloud or VPS hosting with DigitalOcean and receive a $200 credit for 60 days through our link π
https://watsontechworld.com/digitalocean
---
Our website: https://watsontechworld.com
---
#SQL #MySQL #GROUPBY #SQLTutorial #SQLGROUPBY #DataAnalysis #database #LearnSQL
Category
π€
TechTranscript
00:00actually how i did it in um in a real database so the command is select gender comma the average
00:09this this uh an sql average is avg if you type a v e r e g e you'll actually get an error
00:18so you can only do average this way in sql so i did the average of yearly salary from the salary
00:25table group by gender and notice here we have 91 203.75 and that's what that is there
00:35and then the female average is two five six six