Build a table with rules: CREATE TABLE and transactions: interactive SQL lesson

Build a table with rules: CREATE TABLE and transactions · exercise 1 of 1 · free preview

CREATE TABLE name (column type rule, ...) makes a new table. PRIMARY KEY makes a column unique and required. NOT NULL makes a column required.

Create a table called coupons with three columns: code (text, the primary key), percent_off (integer, required) and expires_on (date, may be empty). The check shows how each column is defined.

Tables in this practice shop

customers
customer_id, first_name, last_name, city, joined_on, loyalty_tier
products
product_id, name, category, unit_price
orders
order_id, customer_id, order_date, channel
order_items
order_item_id, order_id, product_id, quantity

Loading lesson…

Build a table with rules: CREATE TABLE and transactions · exercise 1 of 1 · free preview

CREATE TABLE name (column type rule, ...) makes a new table. PRIMARY KEY makes a column unique and required. NOT NULL makes a column required.

Create a table called coupons with three columns: code (text, the primary key), percent_off (integer, required) and expires_on (date, may be empty). The check shows how each column is defined.

Tables in this practice shop

customers
customer_id, first_name, last_name, city, joined_on, loyalty_tier
products
product_id, name, category, unit_price
orders
order_id, customer_id, order_date, channel
order_items
order_item_id, order_id, product_id, quantity