join query to get the maximum value in django orm

[Rajshree Some]

Table1
id                              name                        comment

1	Item1	Bad
2	Item2	Good

 

 

Table2

Id                                                             table1_id                                             marks         

1.	1	23
2.	1	54
3.	2	66
4.	2	55

I want to write a single query to fetch the maxium marks of each item and update the parent table each item comment with bad if the max is less 60 and good if the max is greater that 60