Group By

Group By

SELECT SQL_Data_File_Complete.MPAA_Rating

FROM SQL_Data_File_Complete

GROUP BY SQL_Data_File_Complete.MPAA_Rating;

Group By and Average

SELECT

SQL_Data_File_Complete.Platform,

Avg(SQL_Data_File_Complete.IMDB_Rating)

FROM SQL_Data_File_Complete

GROUP BY SQL_Data_File_Complete.Platform

ORDER BY SQL_Data_File_Complete.Platform DESC;

Group By and Count

SELECT

SQL_Data_File_Complete.Platform,

Count(SQL_Data_File_Complete.IMDB_Rating)

FROM SQL_Data_File_Complete

GROUP BY SQL_Data_File_Complete.Platform

ORDER BY Count(SQL_Data_File_Complete.IMDB_Rating) DESC;

Group By and Sum

SELECT

SQL_Data_File_Complete.Platform,

SUM(SQL_Data_File_Complete.Likability)

FROM SQL_Data_File_Complete

GROUP BY SQL_Data_File_Complete.Platform

ORDER BY SUM(SQL_Data_File_Complete.Likability) DESC;

Group By and Excluding (Having)

SELECT

SQL_Data_File_Complete.MPAA_Rating,

Avg(SQL_Data_File_Complete.IMDB_Rating)

FROM SQL_Data_File_Complete

GROUP BY SQL_Data_File_Complete.MPAA_Rating

HAVING (((SQL_Data_File_Complete.MPAA_Rating)<>"TV-14"))

and (((SQL_Data_File_Complete.MPAA_Rating)<>"G"))

ORDER BY Avg(SQL_Data_File_Complete.IMDB_Rating) DESC;

Group By and Select Top

SELECT TOP 3

SQL_Data_File_Complete.MPAA_Rating,

Avg(SQL_Data_File_Complete.IMDB_Rating)

FROM SQL_Data_File_Complete

GROUP BY SQL_Data_File_Complete.MPAA_Rating

ORDER BY Avg(SQL_Data_File_Complete.IMDB_Rating) DESC;

Group By and Calculate Percentage

SELECT

SQL_Data_File_Complete.MPAA_Rating,

Count(SQL_Data_File_Complete.MPAA_Rating)

AS MPAA_Count,

(select count (*) from SQL_Data_File_Complete)

AS Total,

Round(Count(SQL_Data_File_Complete.MPAA_Rating)

* 100 /

(select count (*) from SQL_Data_File_Complete),2)

AS MPAA_Percent_of_Total

FROM SQL_Data_File_Complete

GROUP BY SQL_Data_File_Complete.MPAA_Rating

ORDER BY Count(SQL_Data_File_Complete.MPAA_Rating) DESC;