@jonahmary17

8 Week SQL Challenge - Case Study 6 (Digital Analysis)

Mar 1 · 1 min read · We are back on track and in the article we answer the questions for the 2. Digital Analysis focus area in the 6th case study: Case Study #6 - Clique Bait How many users are there? SELECT COUNT(DISTI

8 Week SQL Challenge - Case Study 6 (Enterprise Relationship Diagram)

Feb 27 · 1 min read · We are on 6 out of 8 case studies. It has been a journeeeyyyyyy and boy ooo boy it has not been easy. This is not the time to give up I can smell the bouquet of flowers at the end of all of these (I s

8 Week SQL Challenge - Case Study 5 (Bonus Question)

Feb 24 · 2 min read · The final focus area in Case Study #5 - Data Mart where we solve the Bonus Question. Which areas of the business have the highest negative impact in sales metrics performance in 2020 for the 12 week b

8 Week SQL Challenge - Case Study 5 (Before & After Analysis)

Feb 23 · 3 min read · The focus for this article: 3. Before & After Analysis is to now calculate the total sales and calculate the percentage change in sales amount. This technique is usually used when we inspect an import

8 Week SQL Challenge - Case Study 5 (Data Exploration)

Feb 22 · 1 min read · 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_d