Posted on:

03 Nov 2021

1

Found a mistake in Mock interview 9 - SQL

Hi Tina, i have seen the provided solution in video Mock Interview 9. However i notice a small detail that may lead the SQL code to error.
I see that the `orders.order_date` type is VARCHAR, so that the code inside the CTE - WHERE clause need to add CAST as Date for the order_date column, as well as the date value in filter condition.

I think this code might work, https://codeshare.io/QnkWQ7.

Warm Regards,
Husain Hidayat

0 answers ( 0 marked as helpful)

Submit an answer