Table: blazers_season
Columns: col
date
visitor
score
home
leading_scorer
attendance
record
streak

Question:  what's the home team where streak is l3 and leading scorer is roy : 23
SQL: SELECT "home" FROM blazers_season WHERE "streak" = 'L3' AND "leading_scorer" = 'Roy : 23'

Question:  what's the attendance where score is l 92–101
SQL: SELECT "attendance" FROM blazers_season WHERE "score" = 'L 92–101'

Question: what is the total number of date where visitor is new jersey nets
SQL: SELECT COUNT("date") FROM blazers_season WHERE "visitor" = 'New Jersey Nets'

Question:  who is the leading scorer where home is charlotte bobcats
SQL: SELECT "leading_scorer" FROM blazers_season WHERE "home" = 'Charlotte Bobcats'

Question:  what's the score where record is 0–2
SQL: SELECT "score" FROM blazers_season WHERE "record" = '0–2'

Question: what is the total number of record where streak is l2 and leading scorer is roy : 23
SQL: SELECT COUNT("record") FROM blazers_season WHERE "streak" = 'L2' AND "leading_scorer" = 'Roy : 23'