user: ### NOW ANSWER:
Question: Who directed the episode that was watched by 2.97 million U.S. viewers? 
Columns: ['No. in series', 'Title', 'Directed by', 'Written by', 'Original air date', 'Production code', 'U.S. viewers (million)']
Types: ['real', 'text', 'text', 'text', 'text', 'real', 'text']
Sample row: [1.0, '"Pilot"', 'Michael Lembeck', 'Suzanne Martin', 'June16,2010', 101.0, '4.75']
SQL:

assistant: SELECT "Directed by" FROM "Table" WHERE "U.S. viewers (million)" = '2.97';