Create SQL Table Statement | Dataford Interview Questions

Write a query to create a table in SQL.

Asked in the technical interview stage. Create a PostgreSQL table named sql_records for storing records with an identifier, name, amount, status, and creation timestamp. The table should enforce appropriate required fields, valid status values, nonnegative amounts, and uniqueness for a record name and creation timestamp.

Output

Return the created records with columns record_id, record_name, amount, status, and created_at.
Include one row per record, ordered by amount descending and record_id ascending.

Schema

sql_records

Column	Type	Description
record_idPK	BIGINT	Unique record identifier
record_name	VARCHAR(100)	Name assigned to the record
amount	NUMERIC(12,2)	Nonnegative record amount
status	VARCHAR(20)	Record state
created_at	TIMESTAMPTZ	Timestamp when the record was created

Your question is Create SQL Table Statement. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Write a query to create a table in SQL.

Output

Return the created records with columns record_id, record_name, amount, status, and created_at.
Include one row per record, ordered by amount descending and record_id ascending.

Schema

sql_records

Column	Type	Description
record_idPK	BIGINT	Unique record identifier
record_name	VARCHAR(100)	Name assigned to the record
amount	NUMERIC(12,2)	Nonnegative record amount
status	VARCHAR(20)	Record state
created_at	TIMESTAMPTZ	Timestamp when the record was created

Your question is Create SQL Table Statement. Start with the requirements and the one table in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.