select a.TOTAL_MT, a.TOTAL_EXITO_MT_VAS,a.TASA_MT, b.TOTAL_MO, b.TOTAL_EXITO_MO_VAS, b.TASA_MO
FROM (
SELECT
COUNT (SM_ID) TOTAL_MT,
SUM ((case when SM_STATUS= 1 then 1 else 0 end)) TOTAL_EXITO_MT_VAS,
ROUND (( (SUM ((case when SM_STATUS= 1 then 1 else 0 end)) / COUNT (SM_ID)) * 100),2) TASA_MT
FROM VAS.SMS_DATA_SMC R1
WHERE SUBMISSION_TIME >= TO_DATE ('16/12/2018 00:00:00', 'dd/mm/yyyy HH24:MI:SS')
AND SUBMISSION_TIME <= TO_DATE ('16/12/2018 23:59:59', 'dd/mm/yyyy HH24:MI:SS')
AND MT_MSC_ADDR IS NOT NULL

$arr = [

"I4" => 7 , "I3" => 7 ,
"I2" => 7 , "I1" => 8 ,

"B4" => 8 , "B3" => 8 ,
"B2" => 8 , "B1" => 9 ,

"S4" => 10 , "S3" => 10 ,
"S2" => 10.50 , "S1" => 12 ,

"G4" => 15 , "G3" => 15.50 ,
"G2" => 16 , "G1" => 17 ,

"P4" => 27 , "P3" => 28 ,
"P2" => 30 , "P1" => 35 ,

"D4" => 70 , "D3" => 80 ,
"D2" => 120 , "D1" => 180

];

$select1 = "I4";
$select2 = "D3";

$p1 = array_search($select1 ,array_keys($arr));
$p2 = array_search($select2 ,array_keys($arr));
$res = 0;

for($i = $p1; $i < $p2; $i++){