In this video, I show you how to calculate the mean, median and mode in SQL, using a dataset showing the ages of the best actor winners at the Oscars.
#sql #statistics #mean #median #mode #datascience #dataanalytics #dataanalyst
📁 Dataset used -
https://data.world/deanchereden/oscar-actor-winners-and-age/workspace/file?filename=Oscar+Actors+winners+and+age.xlsx
📁 SQL Queries -
https://data.world/deanchereden/oscar-actor-winners-and-age/workspace/file?filename=SQL+-+Mean%2C+Median+and+Mode.txt
🔖c h a p t e r s 🔖
00:00 - Intro
00:19 - Load in data
01:11 - Mean (Average)
01:58 - Median
08:25 - Mode
💌 My email - dean@deanchereden.com
🌍 My website - https://www.deanchereden.com
🐦 Twitter - https://twitter.com/deanchereden
🎵 Vhsceral - Gimetime https://chll.to/dd82e17f
🎶 Listen to Chillhop Music - https://youtu.be/kpO-nyGEBJ4