CREATE TABLE table_name_44 (weight__kg_ VARCHAR, name VARCHAR)

What is the weight of John-Michael Liles?
SELECT weight__kg_ FROM table_name_44 WHERE name = "john-michael liles"
SELECT "weight__kg_" FROM "table_name_44" WHERE "john-michael liles" = "name"