ÿþCREATE TABLE [dbo].[MeterReadings](

	[MeterReadingID] [int] NOT NULL,

	[StartTime] [datetime] NOT NULL,

	[VehicleName] [varchar](50) NOT NULL,

	[MeterValue] [int] NOT NULL,

 CONSTRAINT [PK_MeterReadings] PRIMARY KEY CLUSTERED 

(

	[MeterReadingID] ASC

)

)

GO



CREATE TABLE [dbo].[ConsumptionSummary](

	[VehicleName] [varchar](50) NOT NULL,

	[Top20PctAveragePerMinute] [float] NOT NULL,

 CONSTRAINT [PK_ConsumptionSummary] PRIMARY KEY CLUSTERED 

(

	[VehicleName] ASC

)

)