A: Select SUM(UNIX_TIMESTAMP($date)) where record_type = 'I';

B: Select SUM(UNIX_TIMESTAMP($date)) where record_type = 'O';

C: Select COUNT(*)) where record_type = 'I';