Exercise 1,2,4, 7 why not grade
Hello @iambenn,
The outputs must have indentical column names:
Exercise 1) the output looks correct, however it is missing the cell tag ex01
. Could you right click on the cell and choose notebook cell
>add cell tag
and type ex01
.
Exerccise 2) you need to change the column names from average_by_category
to average
, floor_average
to average_down
and ceil_average
to average_up
Exercise 4) at the END of the use column name AS value_rate
instead for amount_category
Exercise 7) use column name delivery
instead of rental_status
@iambenn, continue
Exercise 10) you need to use dim_film
instead of fact_film_actor
and use the correct INNER JOIN:
Use the dim_actor
as the main table for this query. Perform the following joins:
dim_actor
andbridge_actor
table on theactor_id
.fact_rental
andbridge_actor
on therental_id
.dim_film
andfact_rental
on thefilm_id
.
Exercise 11) you need to change the table FROM fact_payment
to fact_rental
and add customer_id = 388 in the WHERE clause.
Exercise 12) here you use the correct WHERE statements, just need to change the FROM fact_payment
to fact_rental
same as in Exercise 11
Could you try apply those changes in column names, remove your code and only post outputs if you need any help. Thank you
Helllo @iambenn,
Exercise 11 has the same structure as Exercise 12, except it uses LAG instead of LEAD and previous_month_amount
instead of next_month_amount
. To fix the difference column change the order in the subtraction, use (LAG(amount, 1) OVER ( ORDER BY month) - amount
Exercise 10 your screenshot is actually 10.2 things you need to change:
- Use FROM
dim_actor
instead offact_film_actor
, - INNER JOIN
bridge_actor
ONbridge_actor.actor_id
=dim_actor.actor_id
- you have a typo bridege_actor in the second JOIN
- keep the last one
dim_film
is correct
Also in 10.4 (graded) you need to take the query in 10.2 and add things:
- name it as
actor_film_count
- use only GROUP BY
actor_id
,without ORDER BY and LIMIT - use ROW_NUMBER and create a column
actor_rank
- finally use a WHERE statement
actor_rank <= 10
Thank you , I finished
@iambenn Could you remove the code, cheers
yes, Thank you