SQL Aggregate and Scalar Functions - MySQL Tutorial #4
First, scalar functions, e.g., ROUND(...), LENGTH(...), and UCASE(...), are discussed. Next, aggregate functions, e.g., AVG(...), COUNT(...), and SUM(...), are discussed.
Link to Playlist: • MySQL Tutorials
◾◾◾◾◾ MySQL Tutorial Playlist ◾◾◾◾◾
1) MySQL Setup, Install, and Basics: • Setup & Install, Basic Queries, Workb...
2) Basic Queries: • Create Tables, Insert & Select Data -...
3) Arithmetic, Comparison, and Logical SQL Operators: • SQL Operators: Arithmetic, Comparison...
4) Aggregate and Scalar Functions: • SQL Aggregate and Scalar Functions - ...
5) SQL Joins: • SQL Inner, Left, and Right Joins - My...
6) If - Then Logic w/ SQL Cases: • SQL IF - THEN Logic w/ Cases - MySQL...
7) Procedures in SQL: • Stored Procedures in SQL - MySQL Tuto...
8) SQL Constraints: • Constraints in SQL - MySQL Tutorial #8
◾◾◾◾◾ Timestamps ◾◾◾◾◾
00:00 | Introduction
00:44 | Scalar Functions
07:00 | Aggregate Functions
◾◾◾◾◾ SQL to Setup Table ◾◾◾◾◾
create table Members(ID int, FirstName varchar(255), LastName varchar(255), Age int, Income int, Job varchar(255))
insert into Members(ID, FirstName, LastName, Age, Income, Job)
Values('001', 'John', 'Oliver', '25', '50000', 'Lawyer'),
('002', 'James', 'Gates', '31', '80000', 'Lawyer'),
('003', 'Kelly', 'Hill', '27', '90000', 'Doctor'),
('004', 'Alf', 'Loft', '35', '50000', 'Engineer'),
('005', 'Charles', 'Booz', '40', '70000', 'Doctor')
◾◾◾◾◾ Related Content ◾◾◾◾◾
🚗 Self-Driving Car in Python: https://youtube.com/playlist?list=PL3...
🕹️ Pygame Tutorials: https://youtube.com/playlist?list=PL3...
🐍 PyCharm Tutorials: https://youtube.com/playlist?list=PL3...
◾◾◾◾◾ Let's Connect! ◾◾◾◾◾
🐦 Twitter (X): 🔗 / @maxrohowsky
📂 GitHub: 🔗 https://github.com/MaxRohowsky
💼 LinkedIn: 🔗 / maxrohowsky
🔊 Discord: 🔗 / discord
✅ Blog: 🔗 https://max.rohowsky.net
◾◾◾◾◾ Hashtags ◾◾◾◾◾
#datascience #mysql #sql