Calculations

Count

SELECT Count(SQL_Data_File_Complete.Title)

FROM SQL_Data_File_Complete;

Average

SELECT Avg(SQL_Data_File_Complete.Likability)

FROM SQL_Data_File_Complete;

Round

SELECT *,

Round(SQL_Data_File_Complete.IMDB_Rating, 0)

AS Rounded_IMDB_Rating

FROM SQL_Data_File_Complete;

Sum

SELECT Sum(SQL_Data_File_Complete.Likability)

FROM SQL_Data_File_Complete;

Sum (Addition)

SELECT *,

Round(SQL_Data_File_Complete.IMDB_Rating, 0)

AS Rounded_IMDB_Rating,

Round (SQL_Data_File_Complete.IMDB_Rating + Rounded_IMDB_Rating, 1)

AS IMDB_SUM

FROM SQL_Data_File_Complete;

Subtract

SELECT *,

Round(SQL_Data_File_Complete.IMDB_Rating, 0)

AS Rounded_IMDB_Rating,

Round (SQL_Data_File_Complete.IMDB_Rating - Rounded_IMDB_Rating, 1)

AS IMDB_Dif

FROM SQL_Data_File_Complete;

Multiply

SELECT *,

Round(SQL_Data_File_Complete.IMDB_Rating, 0)

AS Rounded_IMDB_Rating,

Round (SQL_Data_File_Complete.IMDB_Rating * Rounded_IMDB_Rating, 1)

AS IMDB_Mult

FROM SQL_Data_File_Complete;

Divide

SELECT *,

Round(SQL_Data_File_Complete.IMDB_Rating, 0)

AS Rounded_IMDB_Rating,

Round (SQL_Data_File_Complete.IMDB_Rating / Rounded_IMDB_Rating, 3)

AS IMDB_Divide

FROM SQL_Data_File_Complete;

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;