MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version()

8.0.27

CREATE TABLE employees( emp_id INT PRIMARY KEY, first_name VARCHAR(20), last_name VARCHAR(20), birth_date DATE(), salary DECIMAL(6,2), sex VARCHAR(1), super_id INT, branch_id INT );
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(), salary DECIMAL(6,2), sex VARCHAR(1), super_id INT, branch_id INT )' at line 1

CREATE TABLE employees( emp_id INT PRIMARY KEY, first_name VARCHAR(20), last_name VARCHAR(20), birth_date DATE, salary DECIMAL(6,2), sex VARCHAR(1), super_id INT, branch_id INT );