Decrease Data IO operation on query to lower the DTU cost on Azure
I see a table scan and no use of any indexes in the execution plan. Create indexes to support your query and consider creating one to eliminate the sort. Apply page compression to your tables and any nonclustered indexes. Make sure you are updating stats and indexes - this maintenance is still required in Azure.