Christmas Movies (from Wikipedia list) ranked by IMDb rating

gistfile1.txt

SQLite version 3.11.0 2016-02-15 17:29:24
Enter ".help" for usage hints.
sqlite> SELECT name, rating
   ...>        FROM wikipedia_films
   ...>        JOIN imdb_films
   ...>        USING (name, year)
   ...>        ORDER BY rating DESC
   ...>        LIMIT 100;
It's a Wonderful Life|8.6
Die Hard|8.2
Scrooge|8.1
The Night of the Hunter|8.0
The Nightmare Before Christmas|8.0
A Christmas Story|7.9
Miracle on 34th Street|7.9
The Lion in Winter|7.9
It Happened on Fifth Avenue|7.7
Joyeux Noël|7.7
The Muppet Christmas Carol|7.7
The Muppet Christmas Carol|7.7
Home Alone|7.6
Love Actually|7.6
National Lampoon's Christmas Vacation|7.6
The Bishop's Wife|7.6
White Christmas|7.6
Lethal Weapon|7.6
Kiss Kiss Bang Bang|7.5
The Holly and the Ivy|7.5
Trading Places|7.5
We're No Angels|7.5
A Christmas Carol|7.5
Scrooge|7.5
Christmas in Connecticut|7.4
Female Trouble|7.3
Gremlins|7.3
The Bells of St. Mary's|7.3
Gremlins|7.3
Carol|7.2
Holiday Affair|7.2
I'll Be Seeing You|7.2
Pocketful of Miracles|7.2
Die Hard 2|7.2
Black Christmas|7.2
3 Godfathers|7.1
Arthur Christmas|7.1
The Christmas Chronicles|7.1
The Lemon Drop Kid|7.1
The Christmas Chronicles|7.1
Bad Santa|7.0
The Man Who Invented Christmas|7.0
The Sure Thing|7.0
Scrooged|7.0
Batman Returns|7.0
Jurassic World|7.0
Elf|6.9
Rent|6.9
Rocky IV|6.9
Serendipity|6.9
The Holiday|6.9
The Ref|6.9
The Nutcracker Prince|6.9
Home Alone 2: Lost in New York|6.8
The Family Man|6.8
A Christmas Carol|6.8
Winnie the Pooh: A Very Merry Pooh Year|6.8
Fitzwilly|6.7
Mr. Soft Touch|6.7
While You Were Sleeping|6.7
Christmas a la Mode|6.7
The Great Rupert|6.6
The Polar Express|6.6
Scrooge|6.6
A Christmas Tree Miracle|6.6
Wishin' and Hopin'|6.6
Better Watch Out|6.5
Last Christmas|6.5
Less Than Zero|6.5
Miracle on 34th Street|6.5
One Magic Christmas|6.5
Susan Slept Here|6.5
Better Watch Out|6.5
The Santa Clause|6.5
Prancer|6.4
The Night Before|6.4
Nativity!|6.4
The Christmas Miracle of Jonathan Toomey|6.4
Babes in Toyland|6.3
Noelle|6.3
Period of Adjustment|6.3
Santa Claus: The Movie|6.3
The Family Stone|6.3
The Grinch|6.3
The Ice Harvest|6.3
This Christmas|6.3
Nutcracker Fantasy|6.3
Just Friends|6.2
Noel|6.2
The Christmas Candle|6.2
Why Him?|6.2
Krampus|6.2
Almost Christmas|6.1
Holidate|6.1
Trail of Robin Hood|6.1
Trancers|6.1
A Christmas Snow|6.1
All I Want for Christmas|6.0
Trapped in Paradise|6.0
Christmas Eve|5.9

Worst three:

Saving Christmas|1.4
Krampus: The Reckoning|2.4
Krampus Unleashed|2.4