ตั๋ว Who's the Republican พร้อมตั๋วคอมมิวนิสต์ (ไม่มี) และตั๋ว Socialist ของ joseph g. กระจก?ไม่จำเป็นต้องใช้ทุกโต๊ะ
Who's the Republican ticket with a Communist ticket of (none) and a Socialist ticket of joseph g. glass?It is not neccessary to use all the tables.
 table_name_8:  (republican_ticket [ VARCHAR ] communist_ticket [ VARCHAR ] socialist_ticket [ VARCHAR) ]
SELECT republican_ticket FROM table_name_8 WHERE communist_ticket = "(none)" AND socialist_ticket = "joseph g. glass"