Operations and Metrics Analysis project

I feel its very difficult to solve project 3. I have no idea to solve queries, while i have complete all sql classes once. i feel there will be more contents to solve these queies. where i found the contents to solve these queries.