SWQL Query to calucate percentage

Question

I'm trying to get a percentage using two select queries. The below query is not giving the percent.

individual queries are working fine.

Can you please let me know how to fix this query?

select ((select count(ContainerID)*100 as B
from orion.containerMembers where Name like '%customName%' and Status = 1)/(select count(ContainerID) as A from orion.ContainerMembers where Name like '%CustomName%')) as percent

tony.johnson · Answer

What are the values you are seeing for the individual queries?

krishna gokaraju · Answer

below query works by using JOIN

select (x.A / y.B)  as percentage

from

(select count(containerID) *100  as A

from orion.containermembers

where name like '%NodeName%' and Status = 1)  x

Join

(select count (containerID) as B

from orion.ContainerMembers

where name like '%NodeName%')  Y

ON 1=1

krishna gokaraju · Answer

mismatched input 'percent' expecting identifer in the select clause is the error im getting