Nested Query broken down

query.sql

SELECT name,
FROM projects
JOIN tasks ON projects.id = tasks.project_id;

SELECT name,
  count(tasks.id) as total,
FROM projects
JOIN tasks ON projects.id = tasks.project_id
GROUP BY projects.id;


SELECT name,
  count(tasks.id) as total,
  (SELECT count(*) FROM tasks WHERE tasks.project_id = projects.id AND tasks.completed) as completed
FROM projects
JOIN tasks ON projects.id = tasks.project_id
GROUP BY projects.id;


SELECT name,
  count(tasks.id) as total,
  (SELECT count(*) FROM tasks WHERE tasks.project_id = projects.id AND tasks.completed) as completed
FROM projects
JOIN tasks ON projects.id = tasks.project_id
GROUP BY projects.id
ORDER BY projects.id;

SELECT name,
  count(tasks.id) as total,
  (SELECT count(*) FROM tasks WHERE tasks.project_id = projects.id AND tasks.completed) as completed,
  (SELECT count(*) FROM tasks WHERE tasks.project_id = projects.id AND tasks.completed)::float / count(tasks.id) * 100 as percent
FROM projects
JOIN tasks ON projects.id = tasks.project_id
GROUP BY projects.id
ORDER BY projects.id;