#MySQL #SQL #course

More functions can be found here:
https://dev.mysql.com/doc/refman/8.0/en/built-in-function-reference.html

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;