Sql: how to create a table with specific columns?
Example:
CREATE TABLE users (id INT PRIMARY KEY, username VARCHAR(50), password VARCHAR(50));
The CREATE TABLE statement is used to create a new table in a database.
Solution:
CREATE TABLE employees (id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), department VARCHAR(50));