Execute the following Microsoft SQL Server Transact-SQL (T-SQL) script in Management Studio (SSMS) Query Editor, SQLCMD or other client software to create the zDrugs table, populate it and run a query:

USE [AdventureWorks]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[zDrugs](
[zDrugsID] [int] IDENTITY(1,1) NOT NULL,
[DrugName] [varchar](55) NULL,
[Strength] [varchar](15) NULL,
[Qty] [varchar](20) NULL,
[Type] [varchar](15) NULL,
[PriceUSD] [money] NULL,
[DisplayOnSite] [bit] NULL CONSTRAINT [DF_zDrugs_DisplayOnSite] DEFAULT ((1)),
[CreateDate] [smalldatetime] NULL CONSTRAINT [DF_zDrugs_CreateDate] DEFAULT (getdate()),
[LastUpdate] [smalldatetime] NULL CONSTRAINT [DF_zDrugs_LastUpdate] DEFAULT (getdate()),
[UpdatedBy] [char](10) NULL CONSTRAINT [DF_zDrugs_UpdatedBy] DEFAULT ('')
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF
GO
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('Zaditen (Generic)', '1 mg', '100', 'Generic', 88.64)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('Zebeta (Generic)', '10 mg', '100', 'Generic', 48.88)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('Zebeta (Generic)', '5 mg', '100', 'Generic', 35.37)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('ZOFRAN (ONDANSETRON)', '4mg', '90', 'Generic', 89.00)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('ZOFRAN (ONDANSETRON)', '8mg', '90', 'Generic', 89.00)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('Zyban (Bupropion)', '150mg', '60', 'Generic', 46.31)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('Zyban (Bupropion)', '150mg', '120', 'Generic', 84.84)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('Zyban (Bupropion)', '150mg', '180', 'Generic', 112.40)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('Zyrtec (Cetrine)', '10 mg', '100', 'Generic', 29.95)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('ZYVOX (GENERIC) - known as LINOSPAN', '600mg', '10', 'Generic', 372.61)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('Zaditor (ketotifen) Ophthalmic Solution', '0.25%', '5 ml', 'Brand', 43.75)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('Zaditor (ketotifen) Ophthalmic Solution', '0.25%', '5 ml x 3', 'Brand', 96.40)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('Zafirlukast (Accolate)', '20 mg', '60', 'Brand', 64.87)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('Zafirlukast (Accolate)', '20 mg', '120', 'Brand', 112.72)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('Zafirlukast (Accolate)', '20 mg', '180', 'Brand', 159.76)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('Zanaflex (Tizanidine)', '4 mg', '150', 'Brand', 129.44)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('Zanaflex (Tizanidine)', '4 mg', '450', 'Brand', 353.48)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('Zantac (Ranitidine)', '150 mg', '60', 'Brand', 92.76)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('Zantac Syrup (Ranitidine)', '75 mg/5 mL', '300 mL', 'Brand', 81.53)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('Zarontin (Ethosuximide)', '250 mg', '100', 'Brand', 49.50)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('Zaroxolyn (Metolazone)', '2.5mg', '100', 'Brand', 34.24)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('Zaroxolyn (Metolazone)', '2.5mg', '200', 'Brand', 51.05)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('Zebeta (Monocor in Canada)', '5 mg', '100', 'Brand', 55.82)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('ZEMPLAR', '1 MCG', '30 caps', 'Brand', 185.00)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('ZEMPLAR', '1 MCG', '90 caps', 'Brand', 545.00)
insert dbo.zDrugs (DrugName,Strength,Qty, Type, PriceUSD) values ('ZEMPLAR', '2 MCG', '30 caps', 'Brand', 395.00)
GO
SELECT * FROM zDrugs
WHERE PriceUSD > 100.0
GO