SELECT project.name, project.startdate, project.enddate, SUM(status.completed) as status, users.username
FROM project
LEFT JOIN status ON status.projectid = project.id
LEFT JOIN users ON users.id = project.owner
WHERE SUM(status.completed) / 100 = 1
GROUP BY project.id
ORDER BY enddate ASC