use my_tutorial;
select * from Student WHERE class='Four' and mark between 60 AND 75;
SELECT count(*) FROM `student`WHERE mark  BETWEEN 60 AND 75;
SELECT * FROM student WHERE mark BETWEEN 60 AND 75 AND class='Four';
SELECT * FROM student WHERE mark BETWEEN 60 and 75 AND class IN('Four','Seven');
SELECT * FROM student WHERE mark BETWEEN 60 AND 75 AND class NOT IN('Four','Seven');
SELECT class, COUNT(id) as no   FROM `student` WHERE mark BETWEEN 60 AND 75 GROUP BY class;
SELECT class, SUM( IF( mark <50, 1, 0 ) ) AS grade_C, 
SUM( IF( mark BETWEEN 50 AND 70 , 1, 0 ) ) AS grade_B, 
SUM( IF( mark >70, 1, 0 ) ) AS grade_A 
FROM  `student` GROUP BY class;