Hours statistics development process SQL usage record
/*//Consumption duration Statistics select SUM (Duration) as totalduration, SUM (count) as number, date from STATISTICS_DURATION_CU where School_id= "Test" and date >= "2014-9-28" and date <= "2014-10-17" Group by date order by date Asc*//*sele CT sd.user_id as userid,sd.school_id as schoolid,sd.course_id as CourseID, sd.lecture_id as lecture_id, sum (sd.duration) A S totalduration, SUM (sd.count) as number,sd.date as date from Statistics_duration_cu as SD where sd.school_id= "SWIFTV" G Roup by Sd.date ORDER by Sd.date Desc;*//*select sd.user_id as userid,sd.school_id as schoolid,sd.course_id as CourseId, s d.lecture_id as lecture_id, sum (sd.duration) as Totalduration, sum (sd.count) as number,sd.date as date, cu.title as course Title from Statistics_duration_cu as SD left JOIN course as CU on cu.course_id=sd.course_id where sd.user_id= "HTTIRTD2" and sd.school_id= "Test" GROUP by sd.course_id ORDER by Totalduration desc;*//*//Query The learning situation of all learners of the school count SELECT Count (*) F Rom (SELECT sd.user_id fRom Statistics_duration_cu as SD where sd.school_id= "SWIFTV" GROUP by sd.user_id) as temp;*//*//the learning situation of all students in the school select SD . user_id as userid,sd.school_id as schoolid,sd.course_id as CourseID, sum (sd.duration) as Totalduration, sum (sd.count) as Number,sd.date as date, U.nickname as nickname from Statistics_duration_cu as SD left JOIN user as U on u.user_id=sd.use r_id where sd.school_id= "Swiftv" GROUP by sd.user_id Order by Totalduration Desc;*//*select sd.user_id as Userid,sd.sch ool_id as schoolid,sd.course_id as courseid,sd.lecture_id as Lectureid, section_title as sectiontitle,lecture_title as Le Cturetitle,sum (sd.duration) as Totalduration, sum (sd.count) as number,sd.date from STATISTICS_DURATION_CU as SD where SD. Course_id= "Hxbazkq4" and sd.school_id= "SWIFTV" and sd.date between ' 2014-9-28 ' and ' 2014-10-13 ' GROUP by sd.date order by S D.date DESC *//*//select Count (*) from (SELECT sd.lecture_id from Statistics_duration_cu as SD where sd.course_id= "Hyjgz 2NP "and sd.school_id=" tesT "and user_id=" Httirtd2 "GROUP by lecture_id) as temp;*//*//student Duration (count) for a course is used for paging select COUNT (*) from (select Sd.us er_id from Statistics_duration_cu as SD where sd.course_id= "HYJGZ2NP" and sd.school_id= "test" GROUP by sd.user_id) as Te mp;*//*//the number of records after all courses are grouped SELECT count (*) from (select sd.course_id from Statistics_duration_cu as SD where sd.school_id= " Swiftv "GROUP by sd.course_id) as temp;*//*//management background-Details by time select sd.school_id,sd.course_id as Courseid,sum (sd.duration) A S duration, sum (sd.count) as number,sd.date as date, cu.title as Coursetitle from Statistics_duration_cu as SD left JOIN Course as CU on cu.course_id=sd.course_id where sd.school_id= "test" and sd.date between ' 2014-9-28 ' and ' 2014-10-10 ' Grou P by sd.course_id ORDER by sd.date asc;*//*//Admin background-Details Select sd.school_id,sd.course_id as courseid,sd.lecture_id as lecture Id, Lecture_title as Lecturetitle,sum (sd.duration) as Totalduration, sum (sd.count) as number,sd.date as date from Statisti Cs_duration_cu as SD where Sd.schOol_id= "Test" and sd.course_id= "HYJGZ2NP" GROUP by Lectureid ORDER by totalduration desc;*//*//query time-length statistics for all courses in this school SELECT SD . School_id,sd.course_id,sum (Sd.duration) as Duration, sum (sd.count) as number,sd.date as date, cu.title as Coursetitle fr Om Statistics_duration_cu as SD left JOIN course as cu in cu.course_id=sd.course_id where sd.school_id= "Swiftv" GROUP by course_id ORDER by sd.duration desc;*//*//query for a period of time statistics SELECT sd.user_id as userid,sd.school_id as schoolid,sd.course_id As courseid,sd.lecture_id as Lectureid, section_title as sectiontitle,lecture_title as Lecturetitle,sum (sd.duration) as Totalduration, SUM (sd.count) as number,sd.date from Statistics_duration_cu as SD where sd.course_id= "I0cpf4a8" and Sd.sch Ool_id= ' Swiftv ' and sd.date between ' 2014-9-1 ' and ' 2014-10-5 ' GROUP by Sd.date; *//*select Date_format (DATE, '%y-%m-%d ') as day, school_id as SchoolID, course_id as CourseID, sum (duration) as Totald Uration, SUM (count) as number, date from STATISTICS_DURATION_CU where school_id= ' Swiftv ' and course_id= ' hwcuol4d ' and date_format (date, '%Y ') =2014 and date_format (date, '%m ') =9 GROUP by Da Y order by Day;*//*select sd.user_id,sd.school_id,sd.course_id,sd.lecture_id, Section_title,lecture_title,sum ( Sd.duration) as Duration, sum (sd.count) as number,sd.date from Statistics_duration_cu as SD where sd.course_id= "HWCUOL4D" and sd.school_id= "Swiftv" GROUP by Date;*//*select date_format (date, '%y-%m-%d ') as Day, sum (duration) from Statistics_du RATION_CU where school_id= ' Swiftv ' and date_format (date, '%Y ') =2014 and date_format (date, '%m ') =10 Group by day ORDER by D Ay;*//*select sd.user_id,sd.school_id,sd.course_id,sd.lecture_id, Section_title,lecture_title,sum (sd.duration) as Duration, sum (sd.count) as number,sd.date from Statistics_duration_cu as SD where sd.course_id= "HWCUOL4D" and Sd.school_i D= "SWIFTV" GROUP by date ORDER by Duration desc;*//*select sd.user_id,sd.school_id,sd.course_id,sd.lecture_id, section_ Title,lecture_title,sum (sd.duration) as duration,SUM (sd.count) as number,sd.date from Statistics_duration_cu as SD where sd.course_id= "hwcuol4d" and user_id= "Hz6tvah8" an D sd.school_id= "Swiftv" GROUP by lecture_id ORDER by Sd.duration Desc;*//*select sd.user_id,sd.school_id,sd.course_id, SD.LECTURE_ID, section_title,lecture_title,sd.duration as duration, Sd.count as number,sd.date from Statistics_ Duration_cu as SD where sd.course_id= "hwcuol4d" and user_id= "Hz6tvah8" and sd.school_id= "Swiftv" ORDER by Sd.duration DE sc;*//*select sd.user_id,sd.school_id,sd.course_id,sd.lecture_id, sum (sd.duration) as Duration, sum (sd.count) as Number,sd.date,us.nickname,us.avatar from Statistics_duration_cu as SD left JOIN user as us on sd.user_id=us.user_id wher E sd.course_id= "hwlrt694" and sd.school_id= "Swiftv" GROUP by sd.user_id ORDER by Sd.duration Desc;*//*select sd.user_id,s d.school_id,sd.course_id,sd.lecture_id, SUM (sd.duration) as Duration, sum (sd.count) as Number,sd.date,us.nickname, Us.avatar from Statistics_duration_cu as SD left JOIN usEr as us on sd.user_id=us.user_id where sd.course_id= "hwlrt694" and sd.school_id= "Swiftv" GROUP by Sd.user_id;*//*select User_id,course_id,school_id,lecture_id,sum (Duration), COUNT (PID) from statistics_duration where user_id= "Hz1agerm" and course_id= "Hxbazkq4" and school_id= "SWIFTV"; *//*select * from statistics_duration where course_id= "Hxbazkq4" and School_id= "SWIFTV"; * *
Hours statistics development process SQL usage record