can we use inner join in this ? or we will get wrong result on using inner join ?

@thedatamillennials

7 ай бұрын

you can use the inner join but INNER JOIN is used to combine rows from two or more tables based on a related column between them. The result set includes only the rows that have matching values in the specified columns in both tables.

Can i use group by subscriber_id Instead of group by 1,2,3,4 ??????

@thedatamillennials

Жыл бұрын

Hi @BBOM, First of all apologies for delayed response. and yes my dear friend you can use group by subscriber id instead of group by 1. the only reason that we use group by 1,2..... in our query ,so that we do not have the write the full column name by which we want to group the data. Please do let me know incase if you have any issue with sql queries. And request you to please subscribe our channel for more such contents.

@bbom9197

Жыл бұрын

@@thedatamillennials thanks alot 🤗

@bbom9197

Жыл бұрын

Subscribed

@thedatamillennials

Жыл бұрын

Welcome my dear friend

@thedatamillennials

Жыл бұрын

Thanks for subscribing our channel , really appreciate it. thanks

why left join

@thedatamillennials

Жыл бұрын

Hi Ravi J, Apologies for delayed response. in this video we have used left join because most of the times in your day to day job you will have to use left join with group by by . and that's why I have used left join over here in the example. Please do let me know in case if oyu have any question or concerns.

you still didn't solve bro. haha there is still an error. wtf !

@thedatamillennials

Жыл бұрын

@Ger B Manalo. Dude I think you have not seen the entire video and was so eager to comment that you missed the final output. I would request you to please go through the video once more and watch it till the end, and you will see that the question is solved. Anyways thanks for your postive criticism, we loved it and I would request you to please keep helping us sharings your views. And do let us know how can we improve our content. Cheers mate 🍻

@gerbmanalo2793

Жыл бұрын

@@thedatamillennials okay bro i will look into it.

@thedatamillennials

Жыл бұрын

Thanks @Ger B Manalo.

So complex oo God depressive

@thedatamillennials

5 ай бұрын

Hi malvika Please let me know what makes you feel that joins in sql is complex and depressive, I will try to explain it in more simpler way Thanks in advance, and I will be waiting for your response