THE task is to optimize this query and draw the best possible query tree for this query. Take appropriate database statistics to support your answer, if needed.

Consider the following part of database, and the SQL/RA query: Student (RNO, FirstName, LastName, BirthDate, Gender, CGPA, BatchID, CampusID, DegreeID) Course (CID, Title, CreditHours, Course Level, Course Type, OfferingDept) Grade (Rollno, Course ID, Letter Grade, GPA, Semester, Year, LastUpdate) SELECT S.RNO, S.FirstName, G.LetterGrade FROM student S JOIN grade G ON S.RNO=G.RollNo JOIN course C ON C.CID=G.CourselD WHERE S.CampusID = 'Lhr' AND C.Title='Advance Database Concepts'; RNO, FirstName, LetterGrade (OCampusID="Lhr A Title="Advance Database Concepts (Student RNO-RollNo Grade CourseID=CID Course)