user: ### NOW ANSWER:
Question: What is Detective Donald William Schneider's Cause of death?
Columns: ['Name', 'Rank', 'Tenure', 'Date of death', 'Cause of death']
Types: ['text', 'text', 'text', 'text', 'text']
Sample row: ['James R. Barton', 'Sheriff', '—', '1857-01-23', 'Gunfire']
SQL:

assistant: SELECT "Cause of death" FROM "Table" WHERE "Rank" = 'Detective' AND "Name" = 'Donald William Schneider';