aggregate query

["Raj A" <raj(dot)ayappan(at)gmail(dot)com>]

I have a table

CREATE TABLE survey_load
(
 meter_id character(5) NOT NULL,
 number_of_bays integer NOT NULL,
 bay_1_use integer,
 bay_2_use integer,
 bay_3_use integer,
 bay_4_use integer,
 bay_5_use integer,
 date date NOT NULL,
 inspection_id integer NOT NULL DEFAULT,
)

How do i present an aggregate query

inspection_id  |  meter_id  |  bay_use
1                 12345        (value of bay_1_use)
1                 12345        (value of bay_2_use)
1                 12345        (value of bay_3_use)
2                 23456        (value of bay_1_use)
2                 23456        (value of bay_2_use)
2                 23456        (value of bay_3_use)
2                 23456        (value of bay_4_use)
2                 23456        (value of bay_5_use)

Thanks