I hope you’re doing good!
I’m taking the SQL for Data Analysis course and I’m having trouble with the Joins Implementing parts. I can not make the Task1. Indeed, the query timed out…
My answer may be wrong (notice that I added the column
email_id from the table
emails so I’d be able to sort the table as asked) but I don’t know why. Here is my code below:
select c.customer_id, e.email_id , c.first_name, c.last_name, e.email_subject, e.opened, e.clicked from customers c inner join emails e on c.customer_id = e.customer_id order by 1, 2;
Also, I’m wondering if there is not too much information to show that would be explain the result. My laptop may be not good enough for making this request. I tried to make it on another laptop more performing, but the result is the same…
Please, could anyone give me a clue ?
Thanks a lot!
Have a good one guys!