user: Question: What is the sum number of attendance when the visiting team was charlotte and the leading scorer was ricky davis (23)?
Columns: ['Date', 'Visitor', 'Score', 'Home', 'Leading scorer', 'Attendance', 'Record']
Types: ['text', 'text', 'text', 'text', 'text', 'real', 'text']
Sample row: ['November 1', 'Detroit', '91–80', 'Miami', 'Ricky Davis (23)', 19600.0, '0–1']
SQL:

assistant: SELECT SUM("Attendance") FROM "Table" WHERE "Visitor" = 'charlotte' AND "Leading scorer" = 'ricky davis (23)';