Good:
SELECT
employees.name AS employee_name,
COUNT(tasks.id) AS assigned_task_count
FROM
employees LEFT JOIN tasks
ON employees.id = tasks.id
Bad:
SELECT
employees.name employee_name,
COUNT(tasks.id) assigned_task_count
FROM
employees LEFT JOIN tasks
ON employees.id = tasks.id