sql SELECT customer_name, order_amount FROM customers INNER JOIN orders ON customers.customer_id = orders.customer_id WHERE customers.customer_city = 'Beijing' ORDER BY order_amount DESC; 2. C. Zheng, S. Lee, Z. Wang. (1995). Informix: A Query Optimization. Proceedings of the ACM SIGMOD International Conference on Management of Data.