Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
select
case when StartingIv >= 0 and StartingIv < 0.1 then '0-0.1'
when StartingIv >= 0.1 and StartingIv < 0.2 then '0.1-0.2'
when StartingIv >= 0.2 and StartingIv < 0.3 then '0.2-0.3'
when StartingIv >= 0.3 and StartingIv < 0.4 then '0.3-0.4'
when StartingIv >= 0.4 and StartingIv < 0.5 then '0.4-0.5'
when StartingIv >= 0.5 and StartingIv < 0.6 then '0.5-0.6'
when StartingIv >= 0.6 and StartingIv < 0.7 then '0.6-0.7'
when StartingIv >= 0.7 and StartingIv < 0.8 then '0.7-0.8'
when StartingIv >= 0.8 and StartingIv < 0.9 then '0.8-0.9'
when StartingIv >= 0.9 and StartingIv < 1 then '0.9-1'
when StartingIv >= 1 and StartingIv < 1.1 then '1-1.1'
else 'ELSE'
end as IvRange
, Profit
from Trades
group by case when StartingIv >= 0 and StartingIv < 0.1 then '0-0.1'
when StartingIv >= 0.1 and StartingIv < 0.2 then '0.1-0.2'
when StartingIv >= 0.2 and StartingIv < 0.3 then '0.2-0.3'
when StartingIv >= 0.3 and StartingIv < 0.4 then '0.3-0.4'
when StartingIv >= 0.4 and StartingIv < 0.5 then '0.4-0.5'
when StartingIv >= 0.5 and StartingIv < 0.6 then '0.5-0.6'
when StartingIv >= 0.6 and StartingIv < 0.7 then '0.6-0.7'
when StartingIv >= 0.7 and StartingIv < 0.8 then '0.7-0.8'
when StartingIv >= 0.8 and StartingIv < 0.9 then '0.8-0.9'
when StartingIv >= 0.9 and StartingIv < 1 then '0.9-1'
when StartingIv >= 1 and StartingIv < 1.1 then '1-1.1'
else 'ELSE'
end
select
a.IvRange, sum(Profit) as Profit
FROM
(
select
case when StartingIv >= 0 and StartingIv < 0.1 then '0-0.1'
when StartingIv >= 0.1 and StartingIv < 0.2 then '0.1-0.2'
when StartingIv >= 0.2 and StartingIv < 0.3 then '0.2-0.3'
when StartingIv >= 0.3 and StartingIv < 0.4 then '0.3-0.4'
when StartingIv >= 0.4 and StartingIv < 0.5 then '0.4-0.5'
when StartingIv >= 0.5 and StartingIv < 0.6 then '0.5-0.6'
when StartingIv >= 0.6 and StartingIv < 0.7 then '0.6-0.7'
when StartingIv >= 0.7 and StartingIv < 0.8 then '0.7-0.8'
when StartingIv >= 0.8 and StartingIv < 0.9 then '0.8-0.9'
when StartingIv >= 0.9 and StartingIv < 1 then '0.9-1'
when StartingIv >= 1 and StartingIv < 1.1 then '1-1.1'
else 'ELSE'
end as IvRange
, Profit
from Trades) a
group by IvRange
If you are experiencing a similar issue, please ask a related question
Join the community of 500,000 technology professionals and ask your questions.