Table: james_bond_songs
Columns: film
year
score_composer
u_k_peak_position
u_s_peak_position

Question: Which film was released in 1983?
SQL: SELECT "film" FROM james_bond_songs WHERE "year" = 1983

Question: What was the US Peak position of the film that peaked at #21 in the UK?
SQL: SELECT "u_s_peak_position" FROM james_bond_songs WHERE "u_k_peak_position" = '21'

Question: Who was the score composer of the film released in 1967?
SQL: SELECT "score_composer" FROM james_bond_songs WHERE "year" = 1967

Question: How many years had a film that peaked at #10 in the UK?
SQL: SELECT COUNT("year") FROM james_bond_songs WHERE "u_k_peak_position" = '10'