ALTER TABLE consumption_energy_measurements DROP COLUMN device_serial_number;