What is the middle name of the legislator whose birthday was on 8/24/1956?
birthday was on 8/24/1956 refers to birthday_bio = '1956-08-24'
SELECT middle_name FROM current WHERE birthday_bio = '1956-08-24'