CREATE TABLE authors (
    id BIGINT IDENTITY(1,1) PRIMARY KEY,
    name NVARCHAR(100) NOT NULL,
    bio NVARCHAR(MAX),
    royalties DECIMAL(10,2) NOT NULL,
    created DATETIME2 NOT NULL
);