Exercise: Table with Types
Create employees table with varied types.
Solution
sql
1CREATE TABLE employees (
2 id INTEGER,
3 name VARCHAR(50),
4 salary REAL,
5 hire_date DATE,
6 active BOOLEAN
7);
Create employees table with varied types.
1CREATE TABLE employees (
2 id INTEGER,
3 name VARCHAR(50),
4 salary REAL,
5 hire_date DATE,
6 active BOOLEAN
7);