<reponame>fintelia/habitationi<filename>cambridge/updates.sql
.mode csv
.separator ','
.import tmp/assess2021.csv Properties
alter table Properties add column year_sold integer;
update Properties set year_sold = cast(substr(SALEDATE, -4) as integer);
alter table Properties add column address_only string;
update Properties SET address_only=substr(address, 0, instr(address, '
'));
