Yes
select project_id from projects
Show me the details for the whole project id of the table "projects"
select project_id,project_details from projects
Show me the project id and details for the project with at least two documents
select t1.project_id, t1.project_details from projects as t1 join documents as t2 on t1.project_id = t2.project_id group by t1.project_id having count ( * ) > 2