canal length (miles) locks max length (ft) width (ft) year opened year abandoned year restored
canal
length -lrb- miles -rrb-
locks
max length -lrb- ft -rrb-
width -lrb- ft -rrb-
year opened
year abandoned
year restored
number
number
number
number
number
number
number
text number number number number number number number
aberdeenshire canal 18 18 150 35 1805 1854 2002
crinan canal is only half of what other canal
NNP NNP VBD-AUX RB NN IN WP JJ NN
Aberdeenshire Canal
select c1 from w where c2_number = ( select c2_number from w where c1 = 'crinan canal' ) / 0.5