Foma
- I want to be able to create/update/delete projects
- I want to be able to add tasks to my project
- I want to be able to update/delete tasks
- I want to be able to prioritize tasks into a project
- I want to be able to choose deadline for my task
- I want to be able to mark a task as 'done'
get all statuses, not repeating, alphabetically ordered
- get the count of all tasks in each project, order by tasks count
descending
- get the count of all tasks in each project, order by projects
names
- get the tasks for all projects having the name beginning with
"N" letter
- get the list of all projects containing the 'a' letter in the middle of
the name, and show the tasks count near each project. Mention
that there can exist projects without tasks and tasks with
project_id = NULL
- get the list of tasks with duplicate names. Order alphabetically
- get list of tasks having several exact matches of both name and
status, from the project 'Garage'. Order by matches count
- get the list of project names having more than 10 tasks in status
'completed'. Order by project_id
Спасибо 🤝