Baselight
SELECT *
FROM @kaggle.s4lman_imdb_series_dataset.imdb_series
WHERE rating > 8 AND genre like '%Comedy%'
ORDER BY rating
rankingtitleyeardurationgenreratingdirectorsvotes
4935 Der Clown(1998–2001)45 minAction, Comedy, Crime8.1nan11
6631 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.1nan88
6632 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.1nan108
6643 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.1nan84
6669 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.1nan104
6679 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.1nan108
7875 Get Smart(1965–1970)25 minAction, Adventure, Comedy8.1nan218
7885 Get Smart(1965–1970)25 minAction, Adventure, Comedy8.1nan161
7887 Get Smart(1965–1970)25 minAction, Adventure, Comedy8.1nan162
7895 Get Smart(1965–1970)25 minAction, Adventure, Comedy8.1nan164
7899 Get Smart(1965–1970)25 minAction, Adventure, Comedy8.1nan151
2605 Batman(1966–1968)25 minAction, Adventure, Comedy8.1nan519
7787 Get Smart(1965–1970)25 minAction, Adventure, Comedy8.1nan161
7794 Get Smart(1965–1970)25 minAction, Adventure, Comedy8.1nan186
7377 Fillmore!(2002–2004)23 minAction, Animation, Comedy8.1nan25
7805 Get Smart(1965–1970)25 minAction, Adventure, Comedy8.1nan157
7840 Get Smart(1965–1970)25 minAction, Adventure, Comedy8.1nan226
7843 Get Smart(1965–1970)25 minAction, Adventure, Comedy8.1nan180
6681 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.1nan75
6685 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.1nan89
6729 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.1nan125
2529 Batman(1966–1968)24 minAction, Adventure, Comedy8.1nan301
1127 The Adventures of Brisco County, Jr.(1993–1994)45 minAction, Adventure, Comedy8.1nan157
1130 The Adventures of Brisco County, Jr.(1993–1994)45 minAction, Adventure, Comedy8.1nan154
1817 American Dragon: Jake Long(2005–2007)21 minAnimation, Action, Comedy8.1nan69
2231 The Avengers(1961–1969)52 minAction, Comedy, Crime8.1nan341
6395 The Dukes of Hazzard(1979–1985)49 minAction, Comedy8.1nan173
2563 Batman(1966–1968)25 minAction, Adventure, Comedy8.1nan342
2569 Batman(1966–1968)25 minAction, Adventure, Comedy8.1nan342
2593 Batman(1966–1968)25 minAction, Adventure, Comedy8.1nan304
3921 The Boondocks(2005–2014)22 minAnimation, Action, Comedy8.1Anthony Bell,Lesean Thomas,Regina King,John Witherspoon,Cedric Yarbrough,Gary Anthony Williams441
6348 The Dukes of Hazzard(1979–1985)49 minAction, Comedy8.1nan163
2247 The Avengers(1961–1969)52 minAction, Comedy, Crime8.1Peter Graham Scott,Wolf Rilla,Patrick Macnee,Diana Rigg,Patrick Cargill,Suzanne Lloyd369
2170 The Avengers(1961–1969)52 minAction, Comedy, Crime8.1nan297
7909 Get Smart(1965–1970)30 minAction, Adventure, Comedy8.1nan142
7910 Get Smart(1965–1970)25 minAction, Adventure, Comedy8.1nan222
6610 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.1nan77
6615 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.1nan90
7324 Fastlane(2002–2003)44 minAction, Comedy, Crime8.1nan51
7333 Fastlane(2002–2003)44 minAction, Comedy, Crime8.1nan55
6640 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.2nan73
6658 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.2nan86
6664 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.2nan80
6667 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.2nan76
6674 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.2nan102
7857 Get Smart(1965–1970)25 minAction, Adventure, Comedy8.2nan212
7890 Get Smart(1965–1970)25 minAction, Adventure, Comedy8.2nan185
7897 Get Smart(1965–1970)30 minAction, Adventure, Comedy8.2nan139
7785 Get Smart(1965–1970)25 minAction, Adventure, Comedy8.2nan173
7786 Get Smart(1965–1970)25 minAction, Adventure, Comedy8.2nan161
6689 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.2nan115
6709 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.2nan92
6718 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.2nan102
6724 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.2nan112
2505 Batman(1966–1968)25 minAction, Adventure, Comedy8.2nan411
2510 Batman(1966–1968)25 minAction, Adventure, Comedy8.2nan313
1144 The Adventures of Brisco County, Jr.(1993–1994)93 minAction, Adventure, Comedy8.2nan345
1825 American Dragon: Jake Long(2005–2007)21 minAnimation, Action, Comedy8.2nan62
1832 American Dragon: Jake Long(2005–2007)21 minAnimation, Action, Comedy8.2nan68
151 Lexx(1996–2002)47 minAction, Adventure, Comedy8.2nan221
2142 The Avengers(1961–1969)51 minAction, Comedy, Crime8.2nan308
2152 The Avengers(1961–1969)51 minAction, Comedy, Crime8.2nan293
3928 The Boondocks(2005–2014)23 minAnimation, Action, Comedy8.2nan483
6616 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.2nan74
6617 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.2nan82
6623 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.2nan76
6627 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.2nan95
6628 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.2nan70
7323 Fastlane(2002–2003)43 minAction, Comedy, Crime8.2nan49
7330 Fastlane(2002–2003)44 minAction, Comedy, Crime8.2nan52
6637 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.3nan78
6649 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.3nan85
6652 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.3nan87
6653 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.3nan84
6665 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.3nan85
6671 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.3nan100
7896 Get Smart(1965–1970)30 minAction, Adventure, Comedy8.3nan151
7978 The Girl from U.N.C.L.E.(1966–1967)60 minAction, Adventure, Comedy8.3nan24
7816 Get Smart(1965–1970)25 minAction, Adventure, Comedy8.3nan203
7820 Get Smart(1965–1970)25 minAction, Adventure, Comedy8.3nan171
2978 BeetleBorgs(1996–1998)20 minAction, Adventure, Comedy8.3nan6
6683 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.3nan76
6684 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.3nan94
6687 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.3nan82
6693 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.3nan74
6703 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.3nan74
6711 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.3nan81
6712 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.3nan81
6717 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.3nan87
6727 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.3nan82
1139 The Adventures of Brisco County, Jr.(1993–1994)45 minAction, Adventure, Comedy8.3nan125
1140 The Adventures of Brisco County, Jr.(1993–1994)45 minAction, Adventure, Comedy8.3nan127
1826 American Dragon: Jake Long(2005–2007)21 minAnimation, Action, Comedy8.3nan71
7122 The Fall Guy(1981–1986)60 minAction, Adventure, Comedy8.3nan116
2240 The Avengers(1961–1969)51 minAction, Comedy, Crime8.3nan361
2258 The Avengers(1961–1969)51 minAction, Comedy, Crime8.3nan404
2279 The Avengers(1961–1969)51 minAction, Comedy, Crime8.3nan291
6733 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.3nan98
3929 The Boondocks(2005–2014)22 minAnimation, Action, Comedy8.3nan630
6618 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.3nan87
6619 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.3nan80
6621 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.3nan79
6622 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.3nan136
6626 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.3nan81
7321 Fastlane(2002–2003)44 minAction, Comedy, Crime8.3nan57
7331 Fastlane(2002–2003)43 minAction, Comedy, Crime8.3nan81
4944 Der Clown(1998–2001)45 minAction, Comedy, Crime8.4nan12
6635 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.4nan94
6638 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.4nan72
6647 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.4nan103
6648 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.4nan95
6651 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.4nan90
6654 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.4nan94
6659 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.4nan71
6661 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.4nan75
7784 Get Smart(1965–1970)25 minAction, Adventure, Comedy8.4nan177
7800 Get Smart(1965–1970)25 minAction, Adventure, Comedy8.4nan238
6694 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.4nan101
6704 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.4nan79
6705 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.4nan81
6715 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.4nan82
6725 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.4nan88
1134 The Adventures of Brisco County, Jr.(1993–1994)45 minAction, Adventure, Comedy8.4nan163
2237 The Avengers(1961–1969)51 minAction, Comedy, Crime8.4nan385
2558 Batman(1966–1968)25 minAction, Adventure, Comedy8.4nan362
2562 Batman(1966–1968)25 minAction, Adventure, Comedy8.4nan386
2271 The Avengers(1961–1969)52 minAction, Comedy, Crime8.4nan416
2191 The Avengers(1961–1969)51 minAction, Comedy, Crime8.4nan333
6624 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.4nan73
2128 The Avengers(1961–1969)52 minAction, Comedy, Crime8.4nan391
4963 Der Clown(1998–2001)45 minAction, Comedy, Crime8.4nan12
6634 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.5nan85
6636 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.5nan99
6642 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.5nan77
6645 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.5nan95
6655 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.5nan69
6676 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.5nan75
6678 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.5nan79
6686 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.5nan70
6690 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.5nan89
6692 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.5nan105
6697 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.5nan91
6699 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.5nan79
6701 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.5nan62
6706 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.5nan82
6710 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.5nan88
6722 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.5nan78
6723 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.5nan70
2222 The Avengers(1961–1969)60 minAction, Comedy, Crime8.5nan475
3920 The Boondocks(2005–2014)21 minAnimation, Action, Comedy8.5Joe Horne,Lesean Thomas,Regina King,John Witherspoon,Cedric Yarbrough,Gary Anthony Williams558
3922 The Boondocks(2005–2014)22 minAnimation, Action, Comedy8.5Joe Horne,Lesean Thomas,Regina King,John Witherspoon,Cedric Yarbrough,Gary Anthony Williams568
6625 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.5nan85
4962 Der Clown(1998–2001)46 minAction, Comedy, Crime8.5nan12
6656 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.6nan97
6675 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.6nan72
7788 Get Smart(1965–1970)25 minAction, Adventure, Comedy8.6nan231
7378 Fillmore!(2002–2004)23 minAction, Animation, Comedy8.6nan30
6696 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.6nan90
6698 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.6nan70
6700 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.6nan91
6713 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.6nan141
6720 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.6nan90
225 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.6Robert A. Cinader,Randolph Mantooth,Randolph Mantooth,Kevin Tighe,Julie London,Robert Fuller122
2238 The Avengers(1961–1969)52 minAction, Comedy, Crime8.6nan398
6612 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.6nan93
6613 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.6nan94
6630 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.7nan104
6639 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.7nan83
6641 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.7nan72
6657 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.7nan88
6662 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.7nan87
6670 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.7nan94
6672 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.7nan98
6677 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.7nan75
6682 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.7nan84
6695 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.7nan141
6707 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.7nan77
6708 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.7nan129
6721 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.7nan72
6646 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.8nan106
6663 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.8nan77
6673 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.8nan72
7373 Fillmore!(2002–2004)23 minAction, Animation, Comedy8.8nan28
6714 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.8nan106
6726 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.8nan95
6633 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.9nan104
6728 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.9nan151
6611 Emergency!(1972–1979)60 minAction, Adventure, Comedy8.9nan73
6668 Emergency!(1972–1979)60 minAction, Adventure, Comedy9nan87
6730 Emergency!(1972–1979)60 minAction, Adventure, Comedy9.1nan107

Share link

Anyone who has the link will be able to view this.