I would like my report to display something image like as below
so can i know is it how my sql for table has to be when creating it
create table attendance
(
Student_ID VARCHAR2 (15) primary key,
Student_Name VARCHAR2 (50) not null,
"Date1" VARCHAR2 (15) not null,
"Date2" VARCHAR2 (15) not null,
"Date3" VARCHAR2 (15) not null,
"Date4" VARCHAR2 (15) not null,
"Date5" VARCHAR2 (15) not null,
Present number (10),
Late number (10),
Absent number (10),
Total_Attendance number (10)
);
for present, late, absent and total attendance i will be using like countif but this i have to research on it how to use in oracle. I would like to know is this correct the way it should be used for sql in creating table so that i will get a report the looks as in the picture