Wilcom Decostudio E1 5 Portable
Wilcom Embroidery Studio e1.5.
Wilcom Decostudio E2.
Wilcom e2 portable decostudio emb.
Mar 31, 2015 
    e1.5  . Decostudio. Embroidery Studio. Embroidery Workflow. DesignWorkflow. Loading... Wilcom Decostudio E1.5 Portable. Wilcom Decostudio E2 Portable. Wilcom Decostudio E2 Portable.Q:
is there a way to calculate mean in sql?
is there a way to calculate mean from multiple rows of a single column?
Here's my query:
select count(*) as num from
(select 1 as num
UNION
select 1 as num
UNION
select 1 as num
UNION
select 2 as num
UNION
select 3 as num
UNION
select 4 as num
UNION
select 5 as num
UNION
select 5 as num
UNION
select 5 as num
UNION
select 5 as num
)
group by num;
It returns this:
num
5
5
5
5
5
5
5
5
but I need this:
num
5.5
I tried this but it won't work:
select avg(num) as num from
(select 1 as num
UNION
select 1 as num
UNION
select 1 as num
UNION
select 2 as num
UNION
select 3 as num
UNION
select 4 as num
UNION
select 5 as num
UNION
select 5 as num
UNION
select 5 as num
UNION
select 5 as num
)
group by num;
Thanks.
A:
select avg(num) as num 
from
    (select 1 as num
    UNION
    select 1 as num
    UNION
    select 1 as num
    UNION
    select 2 as num
    UNION
    select 3 as num
    UNION
    select 4 as num
    UNION
    select 5 as num
    UNION
    select 5 as num
ac619d1d87

Related links:

Wilcom Decostudio E1 5 Portable 🤜