Employee ID	Birthdate	Salary
001	1973-04-05	25000
002	1984-12-04	30000
003	1990-04-02	35000
004	1974-02-04	35000
005	1987-04-09	40000
006	1969-07-07	35000
007	1987-03-04	40000

Using the table shown above, write a query to find the highest-paid employee for each decade based on their birth dates

2.

Movie ID	Genre	Running Time
001	Action	120
002	Action	135
003	Comedy	125
004	Comedy	135
005	Romance	120
006	Action	125
007	Action	95
008	Romance	110

Using the table given above write a query to find the movie with the highest run time for each category.Using the information from above, divide each movie's run time against the longest run time in its category to create an index.

3.

Employee ID	Year	Salary
001	2018	50000
001	2019	55000
002	2017	45000
002	2018	50000
002	2019	55000
002	2020	55000
003	2017	40000
003	2018	45000
003	2019	45000

Using the table shown above write a query to find employees who have received 3 or more salary raises over the years.