Execute the following script in Query Editor 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