Finding all sql id, sql text, number of executions, execution time between two AWR snap ids in oracle
You can select from the below views.


Historical SQL statistics: DBA_HIST_SQLSTAT
All SQL text: DBA_HIST_SQLTEXT
Map snap_id to actual time: DBA_HIST_SNAPSHOT