Statement: paul holahan only directed episodes for seasons 1 through season 6

Input Table: list of white collar episodes

Step 1: Select rows where 'directed_by' is 'paul holahan'.
no_in_series no_in_season title directed_by written_by us_viewers__million_ original_air_date production_code
47 1 wanted paul holahan jeff eastin 3.21 2012-07-10 bcw401
48 2 most wanted paul holahan mark goffman 2.98 2012-07-17 bcw402
49 3 diminishing returns stefan schwartz jim campolongo 3.01 2012-07-24 bcw403
50 4 parting shots robert duncan mcneill alexandra mcnally 2.82 2012-07-31 bcw404
51 5 honor among thieves arlene sanford joe henderson 2.93 2012-08-14 bcw405
52 6 identity crisis david straiton channing powell 3.89 2012-08-21 bcw406
53 7 compromising positions paul holahan matthew negrete 3.36 2012-08-28 bcw407
54 8 ancient history russell lee fine daniel shattuck 3.38 2012-09-04 bcw408
55 9 gloves off renny harlin mark goffman 3.8 2012-09-11 bcw409
56 10 vested interest russell lee fine jeff eastin 3.41 2012-09-18 bcw410
57 11 family business paul holahan joe henderson 2.77 2013-01-22 bcw411
58 12 brass tacks anton cropper jim campolongo & alexandra mcnally 2.61 2013-01-29 bcw412
59 13 empire city tim dekay channing powell & daniel shattuck 2.28 2013-02-05 bcw413
60 14 shoot the moon russell lee fine matthew negrete & bob derosa 2.42 2013-02-19 bcw414
61 15 the original john kretchmer mark goffman 2.12 2013-02-26 bcw415

Step 2: Extract the numerical value from the 'no_in_season' column then add column 'season' to existing table.
no_in_series no_in_season title directed_by written_by us_viewers__million_ original_air_date production_code
47 1 wanted paul holahan jeff eastin 3.21 2012-07-10 bcw401
48 2 most wanted paul holahan mark goffman 2.98 2012-07-17 bcw402
53 7 compromising positions paul holahan matthew negrete 3.36 2012-08-28 bcw407
57 11 family business paul holahan joe henderson 2.77 2013-01-22 bcw411

Step 3: Select rows where 'season' is less than or equal to 6.
no_in_series no_in_season title directed_by written_by us_viewers__million_ original_air_date production_code season
47 1 wanted paul holahan jeff eastin 3.21 2012-07-10 bcw401 1
48 2 most wanted paul holahan mark goffman 2.98 2012-07-17 bcw402 2
53 7 compromising positions paul holahan matthew negrete 3.36 2012-08-28 bcw407 7
57 11 family business paul holahan joe henderson 2.77 2013-01-22 bcw411 11

Step 4: Use a `CASE` statement to return TRUE if the number of rows is equal to the total number of rows in the table, otherwise return FALSE.
no_in_series no_in_season title directed_by written_by us_viewers__million_ original_air_date production_code season
47 1 wanted paul holahan jeff eastin 3.21 2012-07-10 bcw401 1
48 2 most wanted paul holahan mark goffman 2.98 2012-07-17 bcw402 2

verification_result
TRUE