selecting data in between max date and before 1 month of unique IDs

[#1]

Data Contains unique IDs with different latitudes and longitudes on multiple timestamps.I would like to select the rows of latest 30 days of coordinates for each unique ID.Please help me on how to run the query .This date is in Hive table,below is the sample data.

Regards, Akshay

ID	DATE	Latitude	Longittude
1	8/22/2020	40.73	-73.78
1	8/22/2020 9:11	40.76	-74.55
1	8/21/2020 10:11	40.71	-73.56
2	2/18/2019 3:12	15.71	24.45
2	2/18/2019 6:12	16.44	24.35
2	2/17/2019 6:12	11.45	23.98
3	2/15/2018 6:12	76.87	68.22
3	2/16/2018 7:32	76.43	67.45
3	2/18/2018 8:42	76.44	67.4

[#2]

I am unable to run subquery in where clause