Homework feedback Database Week 1

[shekhardaima]

Most of your queries are correct, here are a few tips and corrections:

-- Find all the task that are marked as done
We can use Alias for table names to avoid typing long names repeatedly.
select t.title, s.name from task t inner join status s on t.status_id = s.id where s.name ='Done';

hyf-homework/databases/week1/firstWeek.sql

Line 7 in 306e8b6

select task.title, status.name from task inner join status on task.status_id = status.id where status.name ='Done';

-- Get the names of all statuses, sorted by the status with most tasks first
We also need to sort in Descending order.
select status.name, count(task.status_id) from task inner join status on task.status_id = status.id group by status.name order by count(task.status_id) desc;

hyf-homework/databases/week1/firstWeek.sql

Lines 20 to 21 in 306e8b6

	-- Get the names of all statuses, sorted by the status with most tasks first
	select status.name, count(task.status_id) from task inner join status on task.status_id = status.id group by status.name;