user: ### NOW ANSWER:
Question: What is the weight number when the distance was 5 ½ f?
Columns: ['Result', 'Race', 'Distance', 'Weight', 'Winner or 2nd', "Pos'n"]
Types: ['text', 'text', 'text', 'real', 'text', 'text']
Sample row: ['–', 'RRC Nursery Hcp', '5 ½ f', 6.11, 'Exact', '1st']
SQL:

assistant: SELECT COUNT("Weight") FROM "Table" WHERE "Distance" = '5 ½ f';