What is the average annual revenue of customers who have shipment weight of less than 65000 pounds?
weight of less than 65000 pounds refers to weight < 65000; average annual revenue refers to AVG(annual_revenue)
SELECT AVG(T1.annual_revenue) FROM customer AS T1 INNER JOIN shipment AS T2 ON T1.cust_id = T2.cust_id WHERE T2.weight < 65000