Table: melrose_episodes_2
Columns: no_in_series
no_in_season
title
director
writer_s
original_air_date
production_code

Question: give the least number of times an episode was shown from 1997-1998
SQL: SELECT MIN("no_in_season") FROM melrose_episodes_2

Question: when was the episode named "the doctor is in... deep" first broadcast 
SQL: SELECT "original_air_date" FROM melrose_episodes_2 WHERE "title" = '"The Doctor Is In... Deep"'

Question: how many times does the episode called "coop de grace" appear 
SQL: SELECT COUNT("no_in_series") FROM melrose_episodes_2 WHERE "title" = '"Coop de Grace"'

Question: what is season 6 sum of both the number of times processing ID 2397162 was assigned and the number of times chip chalmers managed an episode 
SQL: SELECT MAX("no_in_season") FROM melrose_episodes_2 WHERE "director" = 'Chip Chalmers' AND "production_code" = '2397162'