Basic Queries

  [WHERE]

·         [GROUP BY]

·         [HAVING]

·         [ORDER BY]

SELECT degree,count(name) from student GROUP BY degrees;

SELECT degree,count(name) from student WHERE year=2 GROUP BY degrees;

SELECT degree as “course”,count(name) from student GROUP BY degrees HAVING count(name)>3;

SELECT *from student ORDER BY name desc;