SELECT / FROM . . . #### mysql> describe timestamps; SESSION INT CUSTOMER INT TIME TIMESTAMP ENTRY TINYINT . . . mysql> #### SELECT SUM(UNIX_TIMESTAMP(b.time) - UNIX_TIMESTAMP(a.time)) FROM timestamps a, timestamps b WHERE a.session = b.session AND a.entry = 1 AND b.entry = 0 ; SELECT COUNT( * ) FROM timestamps WHERE entry = 1 ;