SELECT src,dst , CASE billsec % 6 WHEN 0 THEN ((( (billsec/6) *6)::float(1)/60)::float(1))::float(1) ELSE ((( ((billsec/6 +1)* 6))::float(1)/60)::float(1))::float(1) END as minutes ,accountcode, CASE accountcode WHEN 'INTRA' THEN .035 ELSE .025 END as RATE, CASE accountcode WHEN 'INTRA' THEN CASE billsec % 6 WHEN 0 THEN ((( (billsec/6) *6)::float(1)/60)::float(1)*.035)::float(1) ELSE ((( ((billsec/6 +1)* 6))::float(1)/60)::float(1)*.035)::float(1) END ELSE CASE billsec % 6 WHEN 0 THEN ((( (billsec/6) *6)::float(1)/60)::float(1)*.025)::float(1) ELSE ((( ((billsec/6 +1)* 6))::float(1)/60)::float(1)*.025)::float(1) END END as amount FROM "public".cdr WHERE calldate >= '11/01/2004' and calldate < '12/01/2004' and billsec > 0 and (src like '843%') order by dst;