Functions in MySQL are easy

#MySQL #SQL #course

More functions can be found here:
https://dev.mysql.com/doc/refman/8.0/...

SELECT COUNT(amount) as count
FROM transactions;

SELECT MAX(amount) AS maximum
FROM transactions;

SELECT MIN(amount) AS minimum
FROM transactions;

SELECT AVG(amount) AS average
FROM transactions;

SELECT SUM(amount) AS sum
FROM transactions;

SELECT CONCAT(first_name, “ ”, last_name) AS full_name
FROM employees;

• #education
• #mysql_tutorial_for_beginners
• #sql_tutorial_for_beginners
• #mysql_course
• #sql_course