user: Question: How many millions of viewers did the episode written by Andrea Conway Kagey?
Columns: ['Series #', 'Season #', 'Title', 'Directed by', 'Written by', 'Original air date', 'U.S. viewers (in millions)']
Types: ['real', 'real', 'text', 'text', 'text', 'text', 'text']
Sample row: [41.0, 1.0, '"Smells Like a Winner" "Smells Like Winner"', 'Michael Schultz', 'Kerry Lenhart & John J. Sakmar', 'March26,2012', '1.57']
SQL:

assistant: SELECT "U.S. viewers (in millions)" FROM "Table" WHERE "Written by" = 'Andrea Conway Kagey';