Create the Products Table
Easysql
Learn the Concept: CREATE TABLEWrite a CREATE TABLE statement for a table named products with exactly these columns, in this order: id (INTEGER, primary key), name (TEXT, cannot be NULL), price (INTEGER, cannot be NULL). No rows exist yet — the checker will insert a row and read it back to confirm your table's shape is correct.
Example 1
Input
(none)
Output
id name price 1 Pen 10
Declare each column with its type and constraint, matching the exact column order given. Reference: CREATE TABLE products (id INTEGER PRIMARY KEY, name TEXT NOT NULL, price INTEGER NOT NULL);
Related Problems
- Employees Without a ManagerEasy · sqlSolve Problem
- Engineering Team by SalaryEasy · sqlSolve Problem
- Duplicate EmailsEasy · sqlSolve Problem