{mentor edit: code image removed}
I’m not sure what I’m doing wrong, but I can’t even solve the first exercise of the assignment after a couple of hours working on it.
Hello @Galladian,
I think you need to Join the dim_category table instead of dim_film with fact_rental in the category_id instead of film_id.
Also you just need to SUM amount (no need for fr) as total amount. And your first clause after the new join no, should be dim_category.name IN travel, family, children. Hope it helps
{mentor edit: code image removed}
Hey, I made some modifications hopefully understanding your advice, but I’m not really sure what this bug means or how to fix it.
I managed to fix it.
@Galladian glad its fixed, could you remove the code since sharing is against the code of conduct. Thank you
Sorry
1 Like