Table: ny_undercover_episodes
Columns: series
season
title
directed_by
written_by
musical_guest_and_song
original_air_date
production_code

Question: How many musical guests and songs were in episodes with a production code k0519?
SQL: SELECT COUNT("musical_guest_and_song") FROM ny_undercover_episodes WHERE "production_code" = 'K0519'

Question: How many episodes originally aired on August 31, 1995?
SQL: SELECT COUNT("title") FROM ny_undercover_episodes WHERE "original_air_date" = 'August 31, 1995'

Question: What's the musical guest and the song in the episode titled "Checkmate"?
SQL: SELECT "musical_guest_and_song" FROM ny_undercover_episodes WHERE "title" = '"Checkmate"'

Question: How many episodes were titled "Man's best friend"?
SQL: SELECT COUNT("directed_by") FROM ny_undercover_episodes WHERE "title" = '"Man''s Best Friend"'