Update Employee Sex Codes in SQL

EasySQL · PostgreSQL

Problem

I need to update a table where '1' and '0' were incorrectly assigned for employee sex; how can I change '1' to represent females and '0' to represent males? Write a PostgreSQL statement that updates only these two codes and leaves NULL or other values unchanged.

Output

Return one row per updated employee with employee_id and the corrected sex.
Sort rows by employee_id ascending.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee name
sex	VARCHAR(20)	Employee sex value, including incorrectly coded and corrected values
department	VARCHAR(50)	Employee department

Tablesemployees

CodePostgreSQL

You need to log in / sign up to run or submit.Ln 1

Run your query to see results here.