Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
col a heading “Questions” format a9
col b heading “Values” format 999
select decode(question_no,1,’1-3’,2,’1-3’,3,’1-3’
,4,’4-5’,5,’4-5’,6,’4-5’)a
,sum(answer)b
from table_a
group by decode(question_no,1,’1-3’,2,’1-3’,3,’1-3’
,4,’4-5’,5,’4-5’,6,’4-5’);
Questions Values
--------- ------
1-3 100
4-5 90