Need help optmizing query

[Pascual Angulo]

I am writing code to allow a customers to check how many times a transaction fee
was charged last month. The database is MySQL and my goal is to optimize this query as much as I can.

Where should I start? This is what I have so far:

SELECT cus.*, tran.*, FROM customers cus LEFT JOIN transactions tran on
tran.c_id = cus.c_id where cus.name='$c_name' ORDER BY
cus.name ASC, tran.date DESC;

Thanks in advance for any help.