What is the average top tube length for a 54 cm (frame size) road bike built in 1999?

AvgOfTopTube

On average, which costs (list price) more: road tires or mountain bike tires?

Road

AvgOfListPrice

In May 2003, which employees sold road bikes that they also painted?

EmployeeID

LastName

In 2002, was the Old English letter style more popular with some paint jobs?

PaintID

ColorName

Number of Bikes Painted

Which race bikes in 2003 sold for more than the average price of race bikes in 2002?

SerialNumber

ModelType

OrderDate

SalePrice

Which component that had no sales (installations) in 2004 has the highest inventory value (cost basis)?

ManufacturerName

ProductNumber

Category

Value

ComponentID