SELECT cast((SELECT COUNT(*)
FROM outage
WHERE (starttime BETWEEN '2003-7-20' AND '2003-7-27') AND place = '北京')
/
(SELECT COUNT(*)+0.0
FROM outage
WHERE (place LIKE '北京')) as numeric(10,2)) AS Expr1
FROM outage
WHERE (starttime BETWEEN '2003-7-20' AND '2003-7-27') AND place = '北京')
/
(SELECT COUNT(*)+0.0
FROM outage
WHERE (place LIKE '北京')) as numeric(10,2)) AS Expr1
thank you so much
SELECT cast((SELECT COUNT(*)
FROM outage
WHERE (starttime BETWEEN '2003-7-20' AND '2003-7-27') AND place = '北京') as decimal(20,2))
/
(SELECT COUNT(*)
FROM outage
WHERE (place LIKE '北京')) AS Expr1
Select 5.0/10 -- 0.5