maryjonah.hashnode.dev8 Week SQL Challenge - Case Study 5 (Data Exploration) Here we go with responses to questions in the second focus area: 2. Data Exploration of Case Study #5 - Data Mart What day of the week is used for each week_date value? SELECT DISTINCT DAYNAME(week_d19h ago·1 min read
maryjonah.hashnode.dev8 Week SQL Challenge - Case Study 5 (Data Cleansing Steps)Welcome to Case Study #5 - Data Mart and the section 1. Data Cleansing Steps In a single query, perform the following operations and generate a new table in the data_mart schema named clean_weekly_sal1d ago·2 min read
maryjonah.hashnode.dev8 Week SQL Challenge - Case Study 4 (Data Allocation Challenge)This focus area: C. Data Allocation Challenge needed a lot of brainstorming between me and Claude AI. The summary of this focus area is that the bank has decided that data allocation will be based on The customer’s balance at the end of the previous...5d ago·1 min read
maryjonah.hashnode.dev8 Week SQL Challenge - Case Study 4 (Customer Transactions)Moving on to focus area: B. Customer Transactions which is all about the customers and the transactions they have performed with Data Bank What is the unique count and total amount for each transaction type? SELECT txn_type, COUNT(txn_type) ...5d ago·2 min read
maryjonah.hashnode.dev8 Week SQL Challenge - Case Study 4 (Customer Nodes Exploration)Case Study #4 - Data Bank We are on the fourth (4th) out of 8 case studies: 🎊🥂. We are halfway through the marathon.This time around Danny has a company which is an intersection between “AWS Bucket and your favorite online bank”. Danny does have a ...6d ago·2 min read