How to make the queries: all the task of a project during a period and all projects with tasks marked within the period?

[hiocean]

I have lots of projects each with some fields that can be used and some tasks (or notes) with dates, such as
file project 1.md:

--- type: project tags: tag1, tag2 ---

• [[2021-08-12]] task 1
• [[2021-08-13]] task 2
• [[2021-08-13]] note 1

while the task may also appear in some journals such as [[2021-08-11]], such as :
file [[2021-08-13]].md

• [[project1]] task 1
• [[project2]] task 2

I'd like to make two queries:
(1) a table with the task (note) of a target project during a period e.g. the last month as "task" and its date as "Date"
(2) a list that all projects with tasks with the date in the period?

I know the a period e.g. the last month should be in the where step but i do not know the rest.
need help. Many thanks :)