AVTECH Software interview question

Recommend some fixes to improve query performance in acquiring data.