user: Question: What was Brian Moran's share of the votes when Creigh Deeds had 30%?
Columns: ['Source', 'Dates Administered', 'Terry McAuliffe', 'Brian Moran', 'Creigh Deeds']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['Survey USA', 'June 8', '30%', '21%', '42%']
SQL:

assistant: SELECT "Brian Moran" FROM "Table" WHERE "Creigh Deeds" = '30%';