CREATE TABLE photos (id NUMBER, camera_lens_id NUMBER, mountain_id NUMBER, color CLOB, name CLOB)
CREATE TABLE mountain (id NUMBER, name CLOB, height NUMBER, prominence NUMBER, range CLOB, country CLOB)
CREATE TABLE camera_lens (id NUMBER, brand CLOB, name CLOB, focal_length_mm NUMBER, max_aperture NUMBER)

What are the average prominence of the mountains in country 'Morocco'?
SELECT AVG(prominence) FROM mountain WHERE country = 'Morocco'
SELECT AVG("prominence") FROM "mountain" WHERE "country" = 'Morocco'