Cohomological approaches to the Weil conjectures