How to include days in the average table of cycle data of google analytics in sqllite

Issue

This Content is from Stack Overflow. Question asked by Ajith

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



Solution

This question is not yet answered, be the first one who answer using the comment. Later the confirmed answer will be published as the solution.

This Question and Answer are collected from stackoverflow and tested by JTuto community, is licensed under the terms of CC BY-SA 2.5. - CC BY-SA 3.0. - CC BY-SA 4.0.

people found this article helpful. What about you?