Table: tv_show_guests
Columns: year_s
commentator
dual_commentator
spokesperson
channel

Question: which channels had spokesperson arina sharapova and no dual commentator
SQL: SELECT "channel" FROM tv_show_guests WHERE "spokesperson" = 'Arina Sharapova' AND "dual_commentator" = 'No Dual Commentator'

Question: how many spokesperson where in 2004
SQL: SELECT COUNT("spokesperson") FROM tv_show_guests WHERE "year_s" = 2004

Question: who is the dual commentator at the channel with spokesperson larisa verbickaya
SQL: SELECT "dual_commentator" FROM tv_show_guests WHERE "spokesperson" = 'Larisa Verbickaya'

Question: state all spokesperson for the channel where dual commentator was elena batinova
SQL: SELECT "spokesperson" FROM tv_show_guests WHERE "dual_commentator" = 'Elena Batinova'

Question: state all the spokesperson for the channel where commentator is dmitriy guberniyev
SQL: SELECT "spokesperson" FROM tv_show_guests WHERE "commentator" = 'Dmitriy Guberniyev'