haiselect max(date_att) from attdatabase where dept='cse ' and semester='3' and section='a '
select max(date) from actualtimetable where dept='cse ' and semester='3' and section='a ' and date<'2017-09-20'select date from actualtimetable where confirmed='yes' and semester='3' and dept='cse ' and section='a ' and date not in (select distinct date_att from attdatabase where dept='cse ' and semester='3' and section='a ') and date<'2017-09-20' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-16' and dept='cse ' and semester='3' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-17' and dept='cse ' and semester='3' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-23' and dept='cse ' and semester='3' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-30' and dept='cse ' and semester='3' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-06' and dept='cse ' and semester='3' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-12' and dept='cse ' and semester='3' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-13' and dept='cse ' and semester='3' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-14' and dept='cse ' and semester='3' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-15' and dept='cse ' and semester='3' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-20' and dept='cse ' and semester='3' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-25' and dept='cse ' and semester='3' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-27' and dept='cse ' and semester='3' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-02' and dept='cse ' and semester='3' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-03' and dept='cse ' and semester='3' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-05' and dept='cse ' and semester='3' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-10' and dept='cse ' and semester='3' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-13' and dept='cse ' and semester='3' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-14' and dept='cse ' and semester='3' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-15' and dept='cse ' and semester='3' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-17' and dept='cse ' and semester='3' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-19' and dept='cse ' and semester='3' and section='a 'lab and period no is 1data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='a ' and periodno='1' and subname='JAVALAB 'data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='a ' and periodno='1' and subname='JAVALAB 'lab and period no is 2data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='a ' and periodno='2' and subname='JAVALAB 'data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='a ' and periodno='2' and subname='JAVALAB 'lab and period no is 3data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='a ' and periodno='3' and subname='JAVALAB 'data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='a ' and periodno='3' and subname='JAVALAB 'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='a ' and periodno='4' and subname='MFCS'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='a ' and periodno='5' and subname='JAVA'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='a ' and periodno='5' and subname='JAVA'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='a ' and periodno='6' and subname='ES'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='a ' and periodno='6' and subname='ES'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='a ' and periodno='7' and subname='MFCS'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='a ' and periodno='7' and subname='MFCS'select max(date_att) from attdatabase where dept='cse ' and semester='3' and section='b '
select max(date) from actualtimetable where dept='cse ' and semester='3' and section='b ' and date<'2017-09-20'select date from actualtimetable where confirmed='yes' and semester='3' and dept='cse ' and section='b ' and date not in (select distinct date_att from attdatabase where dept='cse ' and semester='3' and section='b ') and date<'2017-09-20' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-16' and dept='cse ' and semester='3' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-17' and dept='cse ' and semester='3' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-23' and dept='cse ' and semester='3' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-30' and dept='cse ' and semester='3' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-06' and dept='cse ' and semester='3' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-12' and dept='cse ' and semester='3' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-13' and dept='cse ' and semester='3' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-14' and dept='cse ' and semester='3' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-15' and dept='cse ' and semester='3' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-20' and dept='cse ' and semester='3' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-25' and dept='cse ' and semester='3' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-27' and dept='cse ' and semester='3' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-02' and dept='cse ' and semester='3' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-03' and dept='cse ' and semester='3' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-05' and dept='cse ' and semester='3' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-10' and dept='cse ' and semester='3' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-13' and dept='cse ' and semester='3' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-14' and dept='cse ' and semester='3' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-15' and dept='cse ' and semester='3' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-17' and dept='cse ' and semester='3' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-19' and dept='cse ' and semester='3' and section='b 'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='b ' and periodno='1' and subname='MFCS'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='b ' and periodno='1' and subname='MFCS'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='b ' and periodno='2' and subname='JAVA'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='b ' and periodno='2' and subname='JAVA'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='b ' and periodno='3' and subname='DLD'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='b ' and periodno='3' and subname='DLD'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='b ' and periodno='4' and subname='DS'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='b ' and periodno='4' and subname='DS'lab and period no is 5data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='b ' and periodno='5' and subname='ITWLAB'data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='b ' and periodno='5' and subname='ITWLAB'lab and period no is 6data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='b ' and periodno='6' and subname='ITWLAB'data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='b ' and periodno='6' and subname='ITWLAB'lab and period no is 7data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='b ' and periodno='7' and subname='ITWLAB'data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='3' and section='b ' and periodno='7' and subname='ITWLAB'select max(date_att) from attdatabase where dept='cse ' and semester='5' and section='a '
select max(date) from actualtimetable where dept='cse ' and semester='5' and section='a ' and date<'2017-09-20'select date from actualtimetable where confirmed='yes' and semester='5' and dept='cse ' and section='a ' and date not in (select distinct date_att from attdatabase where dept='cse ' and semester='5' and section='a ') and date<'2017-09-20' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-16' and dept='cse ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-17' and dept='cse ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-23' and dept='cse ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-30' and dept='cse ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-06' and dept='cse ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-12' and dept='cse ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-13' and dept='cse ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-14' and dept='cse ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-15' and dept='cse ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-20' and dept='cse ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-25' and dept='cse ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-27' and dept='cse ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-02' and dept='cse ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-03' and dept='cse ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-05' and dept='cse ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-10' and dept='cse ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-13' and dept='cse ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-14' and dept='cse ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-15' and dept='cse ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-17' and dept='cse ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-19' and dept='cse ' and semester='5' and section='a 'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='a ' and periodno='1' and subname='OS'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='a ' and periodno='1' and subname='OS'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='a ' and periodno='2' and subname='CD'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='a ' and periodno='2' and subname='CD'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='a ' and periodno='3' and subname='OS'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='a ' and periodno='3' and subname='OS'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='a ' and periodno='4' and subname='CN'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='a ' and periodno='4' and subname='CN'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='a ' and periodno='5' and subname='PPL'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='a ' and periodno='5' and subname='PPL'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='a ' and periodno='6' and subname='DM'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='a ' and periodno='6' and subname='DM'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='a ' and periodno='7' and subname='SE'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='a ' and periodno='7' and subname='SE'select max(date_att) from attdatabase where dept='cse ' and semester='5' and section='b '
select max(date) from actualtimetable where dept='cse ' and semester='5' and section='b ' and date<'2017-09-20'select date from actualtimetable where confirmed='yes' and semester='5' and dept='cse ' and section='b ' and date not in (select distinct date_att from attdatabase where dept='cse ' and semester='5' and section='b ') and date<'2017-09-20' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-16' and dept='cse ' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-17' and dept='cse ' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-23' and dept='cse ' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-30' and dept='cse ' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-06' and dept='cse ' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-12' and dept='cse ' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-13' and dept='cse ' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-14' and dept='cse ' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-15' and dept='cse ' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-20' and dept='cse ' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-25' and dept='cse ' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-27' and dept='cse ' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-02' and dept='cse ' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-03' and dept='cse ' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-05' and dept='cse ' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-10' and dept='cse ' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-13' and dept='cse ' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-14' and dept='cse ' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-15' and dept='cse ' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-17' and dept='cse ' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-19' and dept='cse ' and semester='5' and section='b 'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='b ' and periodno='1' and subname='CN'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='b ' and periodno='1' and subname='CN'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='b ' and periodno='2' and subname='PPL'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='b ' and periodno='2' and subname='PPL'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='b ' and periodno='3' and subname='CD'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='b ' and periodno='3' and subname='CD'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='b ' and periodno='4' and subname='DM'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='b ' and periodno='4' and subname='DM'lab and period no is 5data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='b ' and periodno='5' and subname='CDLAB'data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='b ' and periodno='5' and subname='CDLAB'lab and period no is 6data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='b ' and periodno='6' and subname='CDLAB'data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='b ' and periodno='6' and subname='CDLAB'lab and period no is 7data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='b ' and periodno='7' and subname='CDLAB'data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='5' and section='b ' and periodno='7' and subname='CDLAB'select max(date_att) from attdatabase where dept='cse ' and semester='7' and section='a '
select max(date) from actualtimetable where dept='cse ' and semester='7' and section='a ' and date<'2017-09-20'select date from actualtimetable where confirmed='yes' and semester='7' and dept='cse ' and section='a ' and date not in (select distinct date_att from attdatabase where dept='cse ' and semester='7' and section='a ') and date<'2017-09-20' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-16' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-17' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-23' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-30' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-06' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-12' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-13' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-14' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-15' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-20' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-25' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-26' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-27' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-02' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-03' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-05' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-10' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-12' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-13' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-14' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-15' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-17' and dept='cse ' and semester='7' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-19' and dept='cse ' and semester='7' and section='a 'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='7' and section='a ' and periodno='1' and subname='CC'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='7' and section='a ' and periodno='1' and subname='CC'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='7' and section='a ' and periodno='2' and subname='LP'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='7' and section='a ' and periodno='2' and subname='LP'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='7' and section='a ' and periodno='3' and subname='CG'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='7' and section='a ' and periodno='3' and subname='CG'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='7' and section='a ' and periodno='4' and subname='IRS'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='7' and section='a ' and periodno='4' and subname='IRS'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='7' and section='a ' and periodno='5' and subname='CG'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='7' and section='a ' and periodno='5' and subname='CG'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='7' and section='a ' and periodno='6' and subname='IRS'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='7' and section='a ' and periodno='6' and subname='IRS'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='7' and section='a ' and periodno='7' and subname='DMDW'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='cse ' and semester='7' and section='a ' and periodno='7' and subname='DMDW'select max(date_att) from attdatabase where dept='ece' and semester='3' and section='a'
select max(date) from actualtimetable where dept='ece' and semester='3' and section='a' and date<'2017-09-20'select date from actualtimetable where confirmed='yes' and semester='3' and dept='ece' and section='a' and date not in (select distinct date_att from attdatabase where dept='ece' and semester='3' and section='a') and date<'2017-09-20' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-16' and dept='ece' and semester='3' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-17' and dept='ece' and semester='3' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-23' and dept='ece' and semester='3' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-30' and dept='ece' and semester='3' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-06' and dept='ece' and semester='3' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-12' and dept='ece' and semester='3' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-13' and dept='ece' and semester='3' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-14' and dept='ece' and semester='3' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-15' and dept='ece' and semester='3' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-20' and dept='ece' and semester='3' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-25' and dept='ece' and semester='3' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-27' and dept='ece' and semester='3' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-02' and dept='ece' and semester='3' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-03' and dept='ece' and semester='3' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-05' and dept='ece' and semester='3' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-10' and dept='ece' and semester='3' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-13' and dept='ece' and semester='3' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-14' and dept='ece' and semester='3' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-15' and dept='ece' and semester='3' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-17' and dept='ece' and semester='3' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-19' and dept='ece' and semester='3' and section='a'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='a' and periodno='1' and subname='NA'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='a' and periodno='1' and subname='NA'lab and period no is 2insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0401','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0402','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0403','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0404','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0405','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0406','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0407','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0408','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0409','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0410','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0412','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0413','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0414','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0415','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0416','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0417','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0418','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0419','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0420','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0421','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0422','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0423','beelab',-1,2)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0424','beelab',-1,2)data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='a' and periodno='2' and subname='edclab'lab and period no is 3insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0401','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0402','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0403','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0404','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0405','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0406','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0407','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0408','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0409','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0410','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0412','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0413','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0414','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0415','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0416','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0417','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0418','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0419','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0420','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0421','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0422','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0423','beelab',-1,3)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0424','beelab',-1,3)data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='a' and periodno='3' and subname='edclab'lab and period no is 4insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0401','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0402','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0403','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0404','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0405','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0406','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0407','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0408','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0409','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0410','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0412','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0413','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0414','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0415','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0416','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0417','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0418','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0419','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0420','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0421','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0422','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0423','beelab',-1,4)insert into attdatabase values('17-18','2017-09-19','ece','a', '3','16UP1A0424','beelab',-1,4)data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='a' and periodno='4' and subname='edclab'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='a' and periodno='5' and subname='NA'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='a' and periodno='5' and subname='NA'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='a' and periodno='6' and subname='AE'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='a' and periodno='6' and subname='AE'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='a' and periodno='7' and subname='EST'select max(date_att) from attdatabase where dept='ece' and semester='3' and section='b'
select max(date) from actualtimetable where dept='ece' and semester='3' and section='b' and date<'2017-09-20'select date from actualtimetable where confirmed='yes' and semester='3' and dept='ece' and section='b' and date not in (select distinct date_att from attdatabase where dept='ece' and semester='3' and section='b') and date<'2017-09-20' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-16' and dept='ece' and semester='3' and section='b' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-17' and dept='ece' and semester='3' and section='b' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-23' and dept='ece' and semester='3' and section='b' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-30' and dept='ece' and semester='3' and section='b' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-06' and dept='ece' and semester='3' and section='b' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-12' and dept='ece' and semester='3' and section='b' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-13' and dept='ece' and semester='3' and section='b' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-14' and dept='ece' and semester='3' and section='b' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-15' and dept='ece' and semester='3' and section='b' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-20' and dept='ece' and semester='3' and section='b' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-25' and dept='ece' and semester='3' and section='b' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-27' and dept='ece' and semester='3' and section='b' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-02' and dept='ece' and semester='3' and section='b' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-03' and dept='ece' and semester='3' and section='b' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-05' and dept='ece' and semester='3' and section='b' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-10' and dept='ece' and semester='3' and section='b' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-13' and dept='ece' and semester='3' and section='b' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-14' and dept='ece' and semester='3' and section='b' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-15' and dept='ece' and semester='3' and section='b' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-17' and dept='ece' and semester='3' and section='b' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-19' and dept='ece' and semester='3' and section='b'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='b' and periodno='1' and subname='SSP'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='b' and periodno='2' and subname='ET'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='b' and periodno='2' and subname='ET'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='b' and periodno='3' and subname='AE'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='b' and periodno='3' and subname='AE'select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='b' and periodno='4' and subname='AE'
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='b' and periodno='4' and subname='AE'lab and period no is 5data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='b' and periodno='5' and subname='bslab'data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='b' and periodno='5' and subname='edclab'lab and period no is 6data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='b' and periodno='6' and subname='bslab'data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='b' and periodno='6' and subname='edclab'lab and period no is 7data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='b' and periodno='7' and subname='bslab'data is there in unconfirmed attdatabase
insert into attdatabase select * from unconfirmed_attdatabase where date_att='2017-09-19' and dept='ece' and semester='3' and section='b' and periodno='7' and subname='edclab'select max(date_att) from attdatabase where dept='ece' and semester='5' and section='a '
select max(date) from actualtimetable where dept='ece' and semester='5' and section='a ' and date<'2017-09-20'select date from actualtimetable where confirmed='yes' and semester='5' and dept='ece' and section='a ' and date not in (select distinct date_att from attdatabase where dept='ece' and semester='5' and section='a ') and date<'2017-09-20' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-16' and dept='ece' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-17' and dept='ece' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-23' and dept='ece' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-30' and dept='ece' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-06' and dept='ece' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-12' and dept='ece' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-13' and dept='ece' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-14' and dept='ece' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-15' and dept='ece' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-20' and dept='ece' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-25' and dept='ece' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-27' and dept='ece' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-02' and dept='ece' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-03' and dept='ece' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-05' and dept='ece' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-10' and dept='ece' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-13' and dept='ece' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-14' and dept='ece' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-15' and dept='ece' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-17' and dept='ece' and semester='5' and section='a 'select max(date_att) from attdatabase where dept='ece' and semester='5' and section='b '
select max(date) from actualtimetable where dept='ece' and semester='5' and section='b ' and date<'2017-09-20'select date from actualtimetable where confirmed='yes' and semester='5' and dept='ece' and section='b ' and date not in (select distinct date_att from attdatabase where dept='ece' and semester='5' and section='b ') and date<'2017-09-20' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-16' and dept='ece' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-17' and dept='ece' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-23' and dept='ece' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-30' and dept='ece' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-06' and dept='ece' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-12' and dept='ece' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-13' and dept='ece' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-14' and dept='ece' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-15' and dept='ece' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-20' and dept='ece' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-25' and dept='ece' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-27' and dept='ece' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-02' and dept='ece' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-03' and dept='ece' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-05' and dept='ece' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-10' and dept='ece' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-13' and dept='ece' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-14' and dept='ece' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-15' and dept='ece' and semester='5' and section='b ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-17' and dept='ece' and semester='5' and section='b 'select max(date_att) from attdatabase where dept='ece' and semester='7' and section='a'
select max(date) from actualtimetable where dept='ece' and semester='7' and section='a' and date<'2017-09-20'select date from actualtimetable where confirmed='yes' and semester='7' and dept='ece' and section='a' and date not in (select distinct date_att from attdatabase where dept='ece' and semester='7' and section='a') and date<'2017-09-20' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-12' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-15' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-16' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-17' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-23' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-30' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-06' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-07' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-12' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-13' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-14' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-15' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-20' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-25' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-26' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-27' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-31' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-02' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-03' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-04' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-05' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-10' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-12' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-13' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-14' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-15' and dept='ece' and semester='7' and section='a' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-17' and dept='ece' and semester='7' and section='a'select max(date_att) from attdatabase where dept='EEE ' and semester='5' and section='a '
select max(date) from actualtimetable where dept='EEE ' and semester='5' and section='a ' and date<'2017-09-20'select date from actualtimetable where confirmed='yes' and semester='5' and dept='EEE ' and section='a ' and date not in (select distinct date_att from attdatabase where dept='EEE ' and semester='5' and section='a ') and date<'2017-09-20' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-12' and dept='EEE ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-16' and dept='EEE ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-17' and dept='EEE ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-23' and dept='EEE ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-07-30' and dept='EEE ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-06' and dept='EEE ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-12' and dept='EEE ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-13' and dept='EEE ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-14' and dept='EEE ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-15' and dept='EEE ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-20' and dept='EEE ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-25' and dept='EEE ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-27' and dept='EEE ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-02' and dept='EEE ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-03' and dept='EEE ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-05' and dept='EEE ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-10' and dept='EEE ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-13' and dept='EEE ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-14' and dept='EEE ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-15' and dept='EEE ' and semester='5' and section='a ' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-17' and dept='EEE ' and semester='5' and section='a 'select max(date_att) from attdatabase where dept='BSH ' and semester='1' and section='ca'
select max(date) from actualtimetable where dept='BSH ' and semester='1' and section='ca' and date<'2017-09-20'select date from actualtimetable where confirmed='yes' and semester='1' and dept='BSH ' and section='ca' and date not in (select distinct date_att from attdatabase where dept='BSH ' and semester='1' and section='ca') and date<'2017-09-20' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-12' and dept='BSH ' and semester='1' and section='ca' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-14' and dept='BSH ' and semester='1' and section='ca' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-15' and dept='BSH ' and semester='1' and section='ca' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-25' and dept='BSH ' and semester='1' and section='ca' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-02' and dept='BSH ' and semester='1' and section='ca' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-05' and dept='BSH ' and semester='1' and section='ca' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-09' and dept='BSH ' and semester='1' and section='ca'select max(date_att) from attdatabase where dept='BSH ' and semester='1' and section='cb'
select max(date) from actualtimetable where dept='BSH ' and semester='1' and section='cb' and date<'2017-09-20'select date from actualtimetable where confirmed='yes' and semester='1' and dept='BSH ' and section='cb' and date not in (select distinct date_att from attdatabase where dept='BSH ' and semester='1' and section='cb') and date<'2017-09-20' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-12' and dept='BSH ' and semester='1' and section='cb' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-14' and dept='BSH ' and semester='1' and section='cb' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-15' and dept='BSH ' and semester='1' and section='cb' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-25' and dept='BSH ' and semester='1' and section='cb' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-02' and dept='BSH ' and semester='1' and section='cb' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-05' and dept='BSH ' and semester='1' and section='cb'select max(date_att) from attdatabase where dept='BSH ' and semester='1' and section='ea'
select max(date) from actualtimetable where dept='BSH ' and semester='1' and section='ea' and date<'2017-09-20'select date from actualtimetable where confirmed='yes' and semester='1' and dept='BSH ' and section='ea' and date not in (select distinct date_att from attdatabase where dept='BSH ' and semester='1' and section='ea') and date<'2017-09-20' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-12' and dept='BSH ' and semester='1' and section='ea' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-14' and dept='BSH ' and semester='1' and section='ea' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-15' and dept='BSH ' and semester='1' and section='ea' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-25' and dept='BSH ' and semester='1' and section='ea' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-02' and dept='BSH ' and semester='1' and section='ea' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-05' and dept='BSH ' and semester='1' and section='ea' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-09' and dept='BSH ' and semester='1' and section='ea'select max(date_att) from attdatabase where dept='BSH ' and semester='1' and section='eb'
select max(date) from actualtimetable where dept='BSH ' and semester='1' and section='eb' and date<'2017-09-20'select date from actualtimetable where confirmed='yes' and semester='1' and dept='BSH ' and section='eb' and date not in (select distinct date_att from attdatabase where dept='BSH ' and semester='1' and section='eb') and date<'2017-09-20' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-12' and dept='BSH ' and semester='1' and section='eb' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-14' and dept='BSH ' and semester='1' and section='eb' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-15' and dept='BSH ' and semester='1' and section='eb' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-25' and dept='BSH ' and semester='1' and section='eb' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-02' and dept='BSH ' and semester='1' and section='eb' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-05' and dept='BSH ' and semester='1' and section='eb' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-09' and dept='BSH ' and semester='1' and section='eb'select max(date_att) from attdatabase where dept='BSH ' and semester='1' and section='ee'
select max(date) from actualtimetable where dept='BSH ' and semester='1' and section='ee' and date<'2017-09-20'select date from actualtimetable where confirmed='yes' and semester='1' and dept='BSH ' and section='ee' and date not in (select distinct date_att from attdatabase where dept='BSH ' and semester='1' and section='ee') and date<'2017-09-20' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-12' and dept='BSH ' and semester='1' and section='ee' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-14' and dept='BSH ' and semester='1' and section='ee' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-15' and dept='BSH ' and semester='1' and section='ee' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-08-25' and dept='BSH ' and semester='1' and section='ee' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-05' and dept='BSH ' and semester='1' and section='ee' select period1,period2,period3,period4,period5,period6,period7 from actualtimetable where date='2017-09-09' and dept='BSH ' and semester='1' and section='ee' ´╗┐mail object createdAvailable{"op":"ok","file":"data:application\/vnd.ms-excel;base64,report.xls"}