Question

How can you replace missing values in the "Country" column with the first non-missing value from "IncidentState" or "City," in that order? Name the new column "Location."

A) UPDATE table_name SET Location = COALESCE(IncidentState, City);
B) ALTER TABLE table_name ALTER COLUMN Country SET Location = COALESCE(IncidentState, City);
C) SELECT COALESCE(IncidentState, City) AS Location FROM table_name;
D) UPDATE table_name SET Location = CASE WHEN IncidentState IS NOT NULL THEN IncidentState ELSE City END

Answer 1

[AI-generated answer — Bot GPT 3.5]

D) UPDATE table_name SET Location = CASE WHEN IncidentState IS NOT NULL THEN IncidentState ELSE City END