Table 'Sales.SpecialOffer', Sale discounts lookup table.

Table 'Sales.SpecialOffer', Sale discounts lookup table.

Property Name	Property Value
Records	16
Fields	11
Record size (bytes) w/o BLOBs	798

Field statistics for 'SpecialOfferID' int identity

Field property	Property Value
Minimum value	1
Maximum value	16
Average value	8.5
Values variance	22.666666666666668
Unique values	16

Field statistics for 'Description' nvarchar(255)

Field property	Property Value
Minimum value	Half-Price Pedal Sale
Maximum value	Volume Discount over 60
Unique values	16

Field statistics for 'DiscountPct' smallmoney(10,4)

Field property	Property Value
Minimum value	.0000
Maximum value	.5000
Average value	0.22
Values variance	2.6066666666666669E-2
Unique values	10

Field statistics for 'Type' nvarchar(50)

Field property	Property Value
Minimum value	Discontinued Product
Maximum value	Volume Discount
Unique values	6

Field statistics for 'Category' nvarchar(50)

Field property	Property Value
Minimum value	Customer
Maximum value	Reseller
Unique values	3

Field statistics for 'StartDate' datetime

Field property	Property Value
Minimum value	2001-06-01 00:00:00.000
Maximum value	2004-05-01 00:00:00.000
Unique values	8

Field statistics for 'EndDate' datetime

Field property	Property Value
Minimum value	2002-06-30 00:00:00.000
Maximum value	2004-12-31 00:00:00.000
Unique values	10

Field statistics for 'MinQty' int

Field property	Property Value
Minimum value	0
Maximum value	61
Average value	9.5625
Values variance	327.32916666666665
Unique values	6

Field statistics for 'MaxQty' int

Field property	Property Value
Minimum value	14
Maximum value	60
Average value	34.5
Values variance	403.66666666666669
Unique values	4

Field statistics for 'rowguid' uniqueidentifier

Field property	Property Value
Unique values	16

Field statistics for 'ModifiedDate' datetime

Field property	Property Value
Minimum value	2001-05-02 00:00:00.000
Maximum value	2004-04-01 00:00:00.000
Unique values	8