model release date sensor
res., size lens (35 mm equiv.)
zoom, aperture screen
size, pixels dimensions
w (mm) × h (mm) × d (mm) weight features
model
release date
sensor res. , size
lens -lrb- 35 mm equiv . -rrb- zoom , aperture
screen size , pixels
dimensions w -lrb- mm -rrb- × h -lrb- mm -rrb- × d -lrb- mm -rrb-
weight
features
number parsed year month day
list length list_number
number
text date text text <n, unitnum> text unitnum text
s01 aug 22, 2012 10.1 mp
3648x2736
1/2.9 in 29-87 mm (3×)
f/3.3-5.9 2.5 in
230 kpixel 77 × 51.2 × 17.2 96 g
(w/batt.) ccd sensor, 2.5 in touch screen, 720p hd video recording, electronic vibration reduction, 7.3 gb internal memory
how many models had a screen size less than 3 inches ?
WRB JJ NNS VBD-AUX DT NN NN JJR IN CD NNS .
5
select count ( c1 ) from w where c5_list_number < 3