Advanced Customer Insights and Product Segmentation Using MS SQLWrite a query to segregate all products into expensive, mid-expensive, and least-expensive categories based on their unit price. Additionally, display the customer's full name, gender, product name, product category, and the unit price of the product.
