You can see varous survey of bird sightings at this website https://www.ornitho.ch/ . I am unforunately not a good ornithologist (or ornithologist at all) to know which species produce sound; however if you filter sightings in the last 15 days, then by canton (select "BE", which is the two letters code for Bern), then look for Bern (Bern is the name of a city but also of a canton, just as there's NY and NYC), then you will see there's at least 20 house sparrow in Bern city.