SELECT avg(Duration) as average_of_days ,member_casual from t4
where weekday==1
and t4.member_casual= "member"
union
select avg(Duration) as average_of_days, member_casual from t4
where weekday==2
and t4.member_casual="member"
After running the execution the answer is in this format averge_of_days member_casual 40.6704059216046 member 53.9774455289958 member
I want to answer in this format average_of_days member_casual 40.6704059216046-Monday member 53.9774455289958-Tuesday member