CREATE TABLE table_name_82 (constellation VARCHAR, hd_designation VARCHAR)

What is Constellation, when HD Designation is 'HD197076'?
SELECT constellation FROM table_name_82 WHERE hd_designation = "hd197076"
SELECT "constellation" FROM "table_name_82" WHERE "hd197076" = "hd_designation"