CareerCup

create table cgpa (name varchar(30), gpa smallint(3));
Insert some values
mysql> select * from cgpa;
+------+------+
| name | gpa  |
+------+------+
| A    |    3 |
| B    |    3 |
| C    |    3 |
| D    |    3 |
| E    |    4 |
| F    |    4 |
| G    |    4 |
| H    |    4 |
| I    |    2 |
| J    |    2 |
| K    |    2 |
| l    |    2 |
| M    |    3 |
| N    |    3 |
+------+------+
mysql> select gpa, count(*) from cgpa where gpa = 3 or gpa = 4 group by gpa;
+------+----------+
| gpa  | count(*) |
+------+----------+
|    3 |        6 |
|    4 |        4 |
+------+----------+

SELECT gpa, count(gpa)
FROM student
WHERE gpa = 3 OR gpa = 4
GROUP BY gpa

Select Grade,
       Count(0)
  From (Select Student_ID,
               Sum(Grade)/Count(0) Grade
          From Student         a,
               Student_Classes b
         Where b.Student_ID = a.Student_ID
         Group By b.Student_ID)
 Where Grade In (3,4)
 Group By Grade

select gpa , count(gpa) over (partition by gpa order by gpa)
from student
where gpa = 3 or gpa = 4

SELECT gpa, count(1)
FROM student
WHERE gpa in (3, 4)
GROUP BY gpa;

select sum( case when grade =3 then 1 else 0 end) as gpa3,
sum(case when grade =4 then 1 else 0 end) as gpa4
from student

SELECT roll_number, mobile_number FROM students WHERE cgpa BETWEEN 7 AND 9 AND year = 'Ill' or year = 'IV'