Sahar Elmukashfi Eltahir Mohamed
Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Last answered:

12 Jul 2023

 Posted on:

11 Jul 2023
0

Code Interpretaion

in Customer Churn Analysis with SQL and Tableau / Query 1 - Net Revenue

Ihave two questions:


1.What is SET sql_mode = '';  for?


2.Why we didnt select Max(p2.purchase_date) as Current_purchase_date


thanks in advanced.

1 answers ( 0 marked as helpful)
Elitsa Kaloyanova
Instructor
Posted on:

12 Jul 2023
0

Hi Sahar, 

thanks for reaching out! To your questions:

1. This is in order to ensure that we do not use the full group by function which is set as default in some of Workbenches versions. You won't usually need to use this command, however, if you receive the error that the query doesn't execute due to a full group by error, you can add this line of code to resolve it.

2. That's a great point, I believe you can create a similar query where you get the maximum purchase date, as the current purchase. 

Let me know if you have any further questions. 


Best, 

365 Eli

Submit an answer