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.

◾◾◾◾◾ MySQL Tutorial Playlist ◾◾◾◾◾

◾◾◾◾◾ 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 ◾◾◾◾◾

◾◾◾◾◾ Let's Connect! ◾◾◾◾◾

◾◾◾◾◾ Hashtags ◾◾◾◾◾
#datascience #mysql #sql

[mauriciohernandez]

I have a question with the next syntaxes: select firstname, lastname, max(income) from members. In the chart I saw John Oliver 90000, but the maximum income belongs to Kelly Hill. Do you know why this error happen? Thanks in advanced.