here is the information you were asking for:

CREATE TABLE [dbo].[Tickets](

[Ticket Number] [int] NOT NULL,

[Priority] [smallint] NULL,

[Assignee] [varchar](25) NULL,

[Category] [varchar](25) NULL,

[Vendor Ticket] [varchar](60) NULL,

[Open Date] [date] NULL,

[Opener] [varchar](30) NULL,

[Closer] [varchar](30) NULL

) ON [PRIMARY]

Also, I already own the Microsoft SQL Server 2012 T-SQL Fundamentals book by Ltzik Ben-Gan.

Thank you for the advise.

Brian