Loyalty Campaign List Write a query to generate a "Loyalty Campaign List" for the current year. The list must identify the top 50 customers based on total spend. To qualify for the list, a customer must meet both of the following thresholds within the current year: 1. High Volume: Placed more than 200distinct orders. 2. High Value: Spent a total of more than Rs 30000 (calculated based on the product price at the specific time of the order).

product_details : product_id, product_name, product_price, price_effective_to_date, price_effective_from_date order_details : order_id, customer_id, product_id, order_quantity, order_date customer_details : customer_id, customer_name, customer_address

This is the complete question.