I am creating a table to get a detailed look at my finances. I want to see cost per day by city and category for the following table schema:Purchasesname, cityName, cost, categoryCitiescityName, daysInCityHow do I create a table with the following fi...
Thanks for the answer! I might have been unclear with the original question. Here is a clarified schema:Purchasesdate, name, cityName, cost, category09/09/24, Dinner at Freddy's, New York, $100.00, Food09/09/24, Lunch, New York, $20.00, Food09/10/24,...
