Table: les_bourgeois_songs
Columns: track
title
translation
composer
recorded

Question: What is the total track that is translated in brussels?
SQL: SELECT COUNT("track") FROM les_bourgeois_songs WHERE "translation" = 'brussels'

Question: Which title has tracks smaller than 7 with translation of an island?
SQL: SELECT "title" FROM les_bourgeois_songs WHERE "track" < 7 AND "translation" = 'an island'

Question: What is the record for Brussels translations?
SQL: SELECT "recorded" FROM les_bourgeois_songs WHERE "translation" = 'brussels'