Write a query in BigQuery

You need to write a query for the data that comes from google analytics 4. It is necessary that the following data be displayed: users, sessions, engage sessions, Average engagement time per session, Engaged sessions per user by sourse/medium and date. There is a ready-made code, but some indicators are not correctly spelled out in it, and several indicators are missing. You can take the code as a basis and correct it, or explain how to calculate these indicators. Next, we want to auto-update it every day through schedule.