T4.8

SELECT "Customer Name", "Product Category", "Profit", "Date" FROM "Sales" WHERE "Region"='East' ORDER BY "Profit" DESC



Here is a SQL of the most profitable products in the eastern region and when it occurred. The purpose is to see where my business is making the most profit.

SELECT "Customer Name", "Product Category", "Profit", "Date" FROM "Sales" WHERE "Customer Name"='Jency Johnah' ORDER BY "Date" DESC



Then I went deeper and looked up the most recent profitable customer and track down her purchased goods in date depending order. The purpose is view costumer loyalty and how my business can provide a better service.

SELECT "Customer Name", "Product Category", "Profit", "Date" FROM "Sales" WHERE "Product Category"='furniture' ORDER BY "Date" DESC



Now I singled out furniture only, so I can get a better view of furniture profits.