sql_task_rubygarage.sql

1. SELECT DISTINCT status FROM tasks ORDER BY name ASC;
2. SELECT count(*) projects.name FROM tasks INNER JOIN projects ON tasks.project_id=projects.id GROUP BY projects.id ORDER BY count(*) DESC;
3. SELECT count(*) projects.name FROM tasks INNER JOIN projects ON tasks.project_id=projects.id GROUP BY projects.id ORDER BY projects.name ASC;
4. SELECT * FROM tasks WHERE name LIKE "N%";
5. SELECT p.name as [Project name], count(tasks) as Quantity FROM projects as p INNGER JOIN tasks as t ON p.id=t.project_Id WHERE mid(p.name, len(name), 1) = 'a' GROUP BY p.name;
6. SELECT name, count(name) as CountOf FROM tasks GROUP BY name, CountOf HAVING count(name) > 1 ORDER BY name ASC;
7. SELECT t.name, t.status, count(*) as "Quantity" FROM projects as p INNER JOIN tasks as t ON p.id=t.project_id WHERE p.name='Garage' GROUP BY t.name, t.status HAVING count(t.name, t.status) > 1 ORDER BY count(t.name, t.status) DESC;
8. SELECT p.name FROM projects as p, tasks as t WHERE p.id=t.project_id AND t.status = 'completed' GROUP BY p.id HAVING count(t.id) > 10 ORDER BY p.project_id;