How to correctly generate a report (for a period of dates) in SQL (MariaDB)?

Question

SQL

Log

Address

result

There is a table with accounting (Log) and a table with addresses (Address). It is necessary to generate a report by date period (Result example) with decomposition into groups and addresses. Tell me, is it possible to do this within one request? (if so, in which direction to dig)

Answer 1

yes, at least dig here