Tag: Tutorial

Return the first non-null expression with COALESCE.

Combine related tables with JOIN operations.

Return matching rows from both tables.

Work with dates using NOW, DATE_ADD, DATE_FORMAT, and differences.

Use ROUND, CEIL, FLOOR, ABS, and arithmetic expressions.

Filter groups after aggregation with HAVING.

Rename columns/tables in queries with AS aliases.

Transform text with CONCAT, SUBSTRING, LENGTH, REPLACE, TRIM, and more.

Add numeric values with SUM().

Compute averages with AVG().