Specific Selection

Select Top

SELECT TOP 85 *

FROM SQL_Data_File_Complete

ORDER BY SQL_Data_File_Complete.Likability;

Select Top %

SELECT TOP 2.75 PERCENT *

FROM SQL_Data_File_Complete

ORDER BY SQL_Data_File_Complete.IMDB_Rating DESC;

Select Range

SELECT *

FROM SQL_Data_File_Complete

WHERE SQL_Data_File_Complete.IMDB_Rating BETWEEN 6.5 and 7.5

ORDER BY SQL_Data_File_Complete.Likability;

Select Top Percentage of Specified Range

SELECT TOP 22.5 PERCENT *

FROM SQL_Data_File_Complete

WHERE

SQL_Data_File_Complete.Year Between 2015 And 2017

AND SQL_Data_File_Complete.Platform="Netflix"

ORDER BY SQL_Data_File_Complete.Likability DESC;

Max

SELECT MAX (SQL_Data_File_Complete.IMDB_Rating)

From SQL_Data_File_Complete;

Min

SELECT MIN (SQL_Data_File_Complete.IMDB_Rating)

From SQL_Data_File_Complete;

Min Row

SELECT top 1 *

FROM SQL_Data_File_Complete

ORDER BY SQL_Data_File_Complete.IMDB_Rating ;

Alternate (Min Row)

SELECT *

FROM SQL_Data_File_Complete

WHERE (((SQL_Data_File_Complete.IMDB_Rating)=(SELECT MIN(IMDB_Rating) FROM SQL_Data_File_Complete)));

Max Row

SELECT top 1 *

FROM SQL_Data_File_Complete

ORDER BY SQL_Data_File_Complete.IMDB_Rating DESC;

Alternate (Max Row)

SELECT *

FROM SQL_Data_File_Complete

WHERE (((SQL_Data_File_Complete.IMDB_Rating)=(SELECT MAX(IMDB_Rating) FROM SQL_Data_File_Complete)));

Grouped Max

SELECT

SQL_Data_File_Complete.MPAA_Rating,

MAX(SQL_Data_File_Complete.IMDB_Rating) AS MAX_IMDB_Rating

FROM SQL_Data_File_Complete

GROUP BY SQL_Data_File_Complete.MPAA_Rating

ORDER BY Min(SQL_Data_File_Complete.imdb_rating) DESC;

Grouped Min

SELECT

SQL_Data_File_Complete.MPAA_Rating,

Min(SQL_Data_File_Complete.IMDB_Rating) AS MIN_IMDB_Rating

FROM SQL_Data_File_Complete

GROUP BY SQL_Data_File_Complete.MPAA_Rating

ORDER BY Min(SQL_Data_File_Complete.imdb_rating) DESC;

Grouped Min W/ Calculation

SELECT SQL_Data_File_Complete.MPAA_Rating, Min(SQL_Data_File_Complete.IMDB_Rating) AS MIN_IMDB_Rating, Min(SQL_Data_File_Complete.imdb_rating) AS Overall_Min, 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 Min(SQL_Data_File_Complete.imdb_rating) DESC;

********************

SELECT

MAX(SQL_Data_File_Complete.Title) AS Title ,

MPAA_Rating,

MAX(SQL_Data_File_Complete.IMDB_Rating) AS IMDB_Rating

FROM SQL_Data_File_Complete

GROUP BY (MPAA_Rating)

ORDER BY MPAA_Rating;

************************

SELECT *

FROM SQL_Data_File_Complete

WHERE

SQL_Data_File_Complete.Year =

(SELECT MAX(Year) FROM SQL_Data_File_Complete)

;