Use the KIMTAY Pet Supplies database. 1.1. Find each customer's total invoice price and categorize it as greater than or lower than 500. Then, group the results by customer ID and sort by the total price in ascending order. Consider an increment of 5% in the original price for all items. Display only those customer IDs with a total price between 250 and 750. 1.2. Use the solution for the problem above as a reference for writing a SQL query that retrieves the total price and the earliest and latest purchase dates for each. Consider a decrease of 5% in the original price for all items. Display only those customer IDs with a total price between 250 and 750. Hint: include the earliest and latest purchase dates in the initial solution.

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.