SELECT count(*) FROM camera_lens WHERE focal_length_mm  >  15
How many camera lenses have a focal length longer than 15 mm?
CREATE TABLE IF NOT EXISTS "mountain" (
"id" int,
"name" text,
"Height" real,
"Prominence" real,
"Range" text,
"Country" text,
primary key("id")
);
CREATE TABLE IF NOT EXISTS "camera_lens" (
"id" int,
"brand" text,
"name" text,
"focal_length_mm" real,
"max_aperture" real,
primary key("id")
);
CREATE TABLE IF NOT EXISTS "photos" (
"id" int, 
"camera_lens_id" int,
"mountain_id" int,
"color" text, 
"name" text,
primary key("id"),
foreign key("camera_lens_id") references `camera_lens`("id"),
foreign key("mountain_id") references `mountain`("id")
);
INSERT INTO mountain VALUES(1,'Abune Yosef / Guliba Amba',4260.0000000000000002,1908.9999999999999999,'Lasta Massif','Ethiopia');
INSERT INTO camera_lens VALUES(1,'Olympus','Olympus 15mm f/8.0 Body Cap',15.0,8.0);
INSERT INTO photos VALUES(1,1,20,'RBG','monkey');