Query: Best Series by Claudia

1SELECT *
2FROM @kaggle.s4lman_imdb_series_dataset.imdb_series
3WHERE rating > 8 AND genre like '%Comedy%'
4ORDER BY rating

ranking	title	year	duration	genre	rating	directors	votes
4935	Der Clown	(1998–2001)	45 min	Action, Comedy, Crime	8.1	nan	11
6631	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.1	nan	88
6632	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.1	nan	108
6643	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.1	nan	84
6669	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.1	nan	104
6679	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.1	nan	108
7875	Get Smart	(1965–1970)	25 min	Action, Adventure, Comedy	8.1	nan	218
7885	Get Smart	(1965–1970)	25 min	Action, Adventure, Comedy	8.1	nan	161
7887	Get Smart	(1965–1970)	25 min	Action, Adventure, Comedy	8.1	nan	162
7895	Get Smart	(1965–1970)	25 min	Action, Adventure, Comedy	8.1	nan	164
7899	Get Smart	(1965–1970)	25 min	Action, Adventure, Comedy	8.1	nan	151
2605	Batman	(1966–1968)	25 min	Action, Adventure, Comedy	8.1	nan	519
7787	Get Smart	(1965–1970)	25 min	Action, Adventure, Comedy	8.1	nan	161
7794	Get Smart	(1965–1970)	25 min	Action, Adventure, Comedy	8.1	nan	186
7377	Fillmore!	(2002–2004)	23 min	Action, Animation, Comedy	8.1	nan	25
7805	Get Smart	(1965–1970)	25 min	Action, Adventure, Comedy	8.1	nan	157
7840	Get Smart	(1965–1970)	25 min	Action, Adventure, Comedy	8.1	nan	226
7843	Get Smart	(1965–1970)	25 min	Action, Adventure, Comedy	8.1	nan	180
6681	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.1	nan	75
6685	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.1	nan	89
6729	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.1	nan	125
2529	Batman	(1966–1968)	24 min	Action, Adventure, Comedy	8.1	nan	301
1127	The Adventures of Brisco County, Jr.	(1993–1994)	45 min	Action, Adventure, Comedy	8.1	nan	157
1130	The Adventures of Brisco County, Jr.	(1993–1994)	45 min	Action, Adventure, Comedy	8.1	nan	154
1817	American Dragon: Jake Long	(2005–2007)	21 min	Animation, Action, Comedy	8.1	nan	69
2231	The Avengers	(1961–1969)	52 min	Action, Comedy, Crime	8.1	nan	341
6395	The Dukes of Hazzard	(1979–1985)	49 min	Action, Comedy	8.1	nan	173
2563	Batman	(1966–1968)	25 min	Action, Adventure, Comedy	8.1	nan	342
2569	Batman	(1966–1968)	25 min	Action, Adventure, Comedy	8.1	nan	342
2593	Batman	(1966–1968)	25 min	Action, Adventure, Comedy	8.1	nan	304
3921	The Boondocks	(2005–2014)	22 min	Animation, Action, Comedy	8.1	Anthony Bell,Lesean Thomas,Regina King,John Witherspoon,Cedric Yarbrough,Gary Anthony Williams	441
6348	The Dukes of Hazzard	(1979–1985)	49 min	Action, Comedy	8.1	nan	163
2247	The Avengers	(1961–1969)	52 min	Action, Comedy, Crime	8.1	Peter Graham Scott,Wolf Rilla,Patrick Macnee,Diana Rigg,Patrick Cargill,Suzanne Lloyd	369
2170	The Avengers	(1961–1969)	52 min	Action, Comedy, Crime	8.1	nan	297
7909	Get Smart	(1965–1970)	30 min	Action, Adventure, Comedy	8.1	nan	142
7910	Get Smart	(1965–1970)	25 min	Action, Adventure, Comedy	8.1	nan	222
6610	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.1	nan	77
6615	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.1	nan	90
7324	Fastlane	(2002–2003)	44 min	Action, Comedy, Crime	8.1	nan	51
7333	Fastlane	(2002–2003)	44 min	Action, Comedy, Crime	8.1	nan	55
6640	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.2	nan	73
6658	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.2	nan	86
6664	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.2	nan	80
6667	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.2	nan	76
6674	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.2	nan	102
7857	Get Smart	(1965–1970)	25 min	Action, Adventure, Comedy	8.2	nan	212
7890	Get Smart	(1965–1970)	25 min	Action, Adventure, Comedy	8.2	nan	185
7897	Get Smart	(1965–1970)	30 min	Action, Adventure, Comedy	8.2	nan	139
7785	Get Smart	(1965–1970)	25 min	Action, Adventure, Comedy	8.2	nan	173
7786	Get Smart	(1965–1970)	25 min	Action, Adventure, Comedy	8.2	nan	161
6689	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.2	nan	115
6709	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.2	nan	92
6718	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.2	nan	102
6724	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.2	nan	112
2505	Batman	(1966–1968)	25 min	Action, Adventure, Comedy	8.2	nan	411
2510	Batman	(1966–1968)	25 min	Action, Adventure, Comedy	8.2	nan	313
1144	The Adventures of Brisco County, Jr.	(1993–1994)	93 min	Action, Adventure, Comedy	8.2	nan	345
1825	American Dragon: Jake Long	(2005–2007)	21 min	Animation, Action, Comedy	8.2	nan	62
1832	American Dragon: Jake Long	(2005–2007)	21 min	Animation, Action, Comedy	8.2	nan	68
151	Lexx	(1996–2002)	47 min	Action, Adventure, Comedy	8.2	nan	221
2142	The Avengers	(1961–1969)	51 min	Action, Comedy, Crime	8.2	nan	308
2152	The Avengers	(1961–1969)	51 min	Action, Comedy, Crime	8.2	nan	293
3928	The Boondocks	(2005–2014)	23 min	Animation, Action, Comedy	8.2	nan	483
6616	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.2	nan	74
6617	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.2	nan	82
6623	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.2	nan	76
6627	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.2	nan	95
6628	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.2	nan	70
7323	Fastlane	(2002–2003)	43 min	Action, Comedy, Crime	8.2	nan	49
7330	Fastlane	(2002–2003)	44 min	Action, Comedy, Crime	8.2	nan	52
6637	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.3	nan	78
6649	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.3	nan	85
6652	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.3	nan	87
6653	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.3	nan	84
6665	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.3	nan	85
6671	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.3	nan	100
7896	Get Smart	(1965–1970)	30 min	Action, Adventure, Comedy	8.3	nan	151
7978	The Girl from U.N.C.L.E.	(1966–1967)	60 min	Action, Adventure, Comedy	8.3	nan	24
7816	Get Smart	(1965–1970)	25 min	Action, Adventure, Comedy	8.3	nan	203
7820	Get Smart	(1965–1970)	25 min	Action, Adventure, Comedy	8.3	nan	171
2978	BeetleBorgs	(1996–1998)	20 min	Action, Adventure, Comedy	8.3	nan	6
6683	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.3	nan	76
6684	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.3	nan	94
6687	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.3	nan	82
6693	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.3	nan	74
6703	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.3	nan	74
6711	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.3	nan	81
6712	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.3	nan	81
6717	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.3	nan	87
6727	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.3	nan	82
1139	The Adventures of Brisco County, Jr.	(1993–1994)	45 min	Action, Adventure, Comedy	8.3	nan	125
1140	The Adventures of Brisco County, Jr.	(1993–1994)	45 min	Action, Adventure, Comedy	8.3	nan	127
1826	American Dragon: Jake Long	(2005–2007)	21 min	Animation, Action, Comedy	8.3	nan	71
7122	The Fall Guy	(1981–1986)	60 min	Action, Adventure, Comedy	8.3	nan	116
2240	The Avengers	(1961–1969)	51 min	Action, Comedy, Crime	8.3	nan	361
2258	The Avengers	(1961–1969)	51 min	Action, Comedy, Crime	8.3	nan	404
2279	The Avengers	(1961–1969)	51 min	Action, Comedy, Crime	8.3	nan	291
6733	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.3	nan	98
3929	The Boondocks	(2005–2014)	22 min	Animation, Action, Comedy	8.3	nan	630
6618	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.3	nan	87
6619	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.3	nan	80
6621	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.3	nan	79
6622	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.3	nan	136
6626	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.3	nan	81
7321	Fastlane	(2002–2003)	44 min	Action, Comedy, Crime	8.3	nan	57
7331	Fastlane	(2002–2003)	43 min	Action, Comedy, Crime	8.3	nan	81
4944	Der Clown	(1998–2001)	45 min	Action, Comedy, Crime	8.4	nan	12
6635	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.4	nan	94
6638	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.4	nan	72
6647	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.4	nan	103
6648	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.4	nan	95
6651	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.4	nan	90
6654	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.4	nan	94
6659	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.4	nan	71
6661	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.4	nan	75
7784	Get Smart	(1965–1970)	25 min	Action, Adventure, Comedy	8.4	nan	177
7800	Get Smart	(1965–1970)	25 min	Action, Adventure, Comedy	8.4	nan	238
6694	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.4	nan	101
6704	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.4	nan	79
6705	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.4	nan	81
6715	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.4	nan	82
6725	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.4	nan	88
1134	The Adventures of Brisco County, Jr.	(1993–1994)	45 min	Action, Adventure, Comedy	8.4	nan	163
2237	The Avengers	(1961–1969)	51 min	Action, Comedy, Crime	8.4	nan	385
2558	Batman	(1966–1968)	25 min	Action, Adventure, Comedy	8.4	nan	362
2562	Batman	(1966–1968)	25 min	Action, Adventure, Comedy	8.4	nan	386
2271	The Avengers	(1961–1969)	52 min	Action, Comedy, Crime	8.4	nan	416
2191	The Avengers	(1961–1969)	51 min	Action, Comedy, Crime	8.4	nan	333
6624	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.4	nan	73
2128	The Avengers	(1961–1969)	52 min	Action, Comedy, Crime	8.4	nan	391
4963	Der Clown	(1998–2001)	45 min	Action, Comedy, Crime	8.4	nan	12
6634	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.5	nan	85
6636	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.5	nan	99
6642	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.5	nan	77
6645	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.5	nan	95
6655	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.5	nan	69
6676	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.5	nan	75
6678	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.5	nan	79
6686	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.5	nan	70
6690	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.5	nan	89
6692	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.5	nan	105
6697	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.5	nan	91
6699	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.5	nan	79
6701	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.5	nan	62
6706	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.5	nan	82
6710	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.5	nan	88
6722	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.5	nan	78
6723	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.5	nan	70
2222	The Avengers	(1961–1969)	60 min	Action, Comedy, Crime	8.5	nan	475
3920	The Boondocks	(2005–2014)	21 min	Animation, Action, Comedy	8.5	Joe Horne,Lesean Thomas,Regina King,John Witherspoon,Cedric Yarbrough,Gary Anthony Williams	558
3922	The Boondocks	(2005–2014)	22 min	Animation, Action, Comedy	8.5	Joe Horne,Lesean Thomas,Regina King,John Witherspoon,Cedric Yarbrough,Gary Anthony Williams	568
6625	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.5	nan	85
4962	Der Clown	(1998–2001)	46 min	Action, Comedy, Crime	8.5	nan	12
6656	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.6	nan	97
6675	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.6	nan	72
7788	Get Smart	(1965–1970)	25 min	Action, Adventure, Comedy	8.6	nan	231
7378	Fillmore!	(2002–2004)	23 min	Action, Animation, Comedy	8.6	nan	30
6696	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.6	nan	90
6698	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.6	nan	70
6700	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.6	nan	91
6713	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.6	nan	141
6720	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.6	nan	90
225	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.6	Robert A. Cinader,Randolph Mantooth,Randolph Mantooth,Kevin Tighe,Julie London,Robert Fuller	122
2238	The Avengers	(1961–1969)	52 min	Action, Comedy, Crime	8.6	nan	398
6612	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.6	nan	93
6613	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.6	nan	94
6630	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.7	nan	104
6639	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.7	nan	83
6641	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.7	nan	72
6657	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.7	nan	88
6662	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.7	nan	87
6670	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.7	nan	94
6672	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.7	nan	98
6677	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.7	nan	75
6682	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.7	nan	84
6695	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.7	nan	141
6707	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.7	nan	77
6708	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.7	nan	129
6721	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.7	nan	72
6646	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.8	nan	106
6663	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.8	nan	77
6673	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.8	nan	72
7373	Fillmore!	(2002–2004)	23 min	Action, Animation, Comedy	8.8	nan	28
6714	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.8	nan	106
6726	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.8	nan	95
6633	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.9	nan	104
6728	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.9	nan	151
6611	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	8.9	nan	73
6668	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	9	nan	87
6730	Emergency!	(1972–1979)	60 min	Action, Adventure, Comedy	9.1	nan	107