Report the titletypes and average of runtimeminutes as "av_runtime" field from title_basics table:

Left join title_basics into title_ratings on tconst fields

Filter for movies genres of which include crime

Start year is between 1950 and 2017

Averagerating from title_ratings is greater than 8

Group by each titletype from title_basics

Include only those groups for which average runtimeminutes is larger than 20

Order by descending average runtime minutes

Output will be :

 titletype | av_runtime --------------+---------------------- tvMiniSeries | 216.3589743589743590 movie | 103.4497257769652651 videoGame | 90.0000000000000000 tvMovie | 88.8551724137931034 tvSpecial | 60.0000000000000000 tvSeries | 58.2183908045977011 video | 58.2142857142857143 tvEpisode | 48.9556956159050885 tvShort | 23.1428571428571429 (9 rows)