用于按字段分组的MySQL子查询

I have a MySQL table called sessions, this table has attendance of sessions attended by user_id with the date. I am able to get average attendance percentage by using the following syntax which basically divides total attended sessions by total possible sessions and multiplies it by 100. This gives me the entire average for the given date range.I have a MySQL table called sessions, this tabl