user: ### NOW ANSWER:
Question: What was the duration of Robert Joy's portrayal?
Columns: ['Character', 'Portrayed by', 'First appearance', 'Last appearance', 'Duration', 'Episodes']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Mac Taylor CSI Detective', 'Gary Sinise', '"Blink" 1, 2, 3', '"Today is Life"', '1.01–9.17', '197']
SQL:

assistant: SELECT COUNT("Duration") FROM "Table" WHERE "Portrayed by" = 'Robert Joy';