Table: heat_20072008
Columns: date
visitor
score
home
leading_scorer
attendance
record

Question: What is the sum number of attendance when the visiting team was Charlotte and the leading scorer was Ricky Davis (23)?
SQL: SELECT COUNT("attendance") FROM heat_20072008 WHERE "visitor" = 'charlotte' AND "leading_scorer" = 'ricky davis (23)'

Question: Which Visitor was there when the Home game was played in Miami on November 4?
SQL: SELECT "visitor" FROM heat_20072008 WHERE "home" = 'miami' AND "date" = 'november 4'