#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;
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
