C3_W3 - Problem with the data ex4 lab1

Course Q&A Data Engineering Data Storage and Queries
1

I’m having difficulty bringing in customer 555 data in exercise 4, apparently the between filter is not working optimally.

image
image1282×638 27.8 KB

image
image661×373 15.8 KB

image
image1300×335 14.2 KB

2

Hello @felipeyamate, it looks like you need to groupby DATE( payment date ) to fix it, thank you

groupby by date
groupby by date1530×186 60 KB

3

Reminder: Sharing code is prohibited by the DeepLearning.AI Code of Conduct. In the future, please keep all work your own to uphold academic integrity. Thank you!

4

Thanks!