Table:
text: Badminton at the Commonwealth Games
Medal table
Medal table
Rank_ Nation Gold Silver Bronze Total
1 England 33 30 34 97
2 Malaysia 24 20 12 56
3 India 4 3 8 15
4 Canada 2 10 6 18
5 Australia 2 1 8 11
6 Singapore 1 3 3 7
7 Scotland 1 1 5 7
8 Hong Kong 1 0 2 3
9 Wales 1 0 1 2
10 New Zealand 0 2 8 10

Question: What are the most gold medals a team has with less than 2 silver medals, more than 7 total medals and less than 8 bronze medals of badminton at the Commonwealth Games?

Question: How many bronze medals does Scotland, who have less than 7 medals in total, have for badminton at the Commonwealth Games?

Question: What are the average silver medals in badminton at the Commonwealth Games that a team with 1 gold and more than 5 bronzes has?

Question: How many bronze medals does a team have in badminton at the Commonwealth Games with more than 0 silver medals, 7 medals in total and less than 1 gold medal?

Question: What is the highest rank for a team with 1 silver and less than 5 bronze medals in badminton at the Commonwealth Games?