user: ### NOW ANSWER:
Question: How many casinos are associated with a July 1, 2008 value of 1865746?
Columns: ['Casinos', 'County', 'Road', '1-Jul-08', 'FY07 $millions', 'FY08 $millions', 'FY09 $millions']
Types: ['real', 'text', 'text', 'real', 'text', 'text', 'text']
Sample row: [149.0, 'Clark', 'I-15', 1865746.0, '$10,538', '$10,172', '$9,081']
SQL:

assistant: SELECT "Casinos" FROM "Table" WHERE "1-Jul-08" = 1865746.0;