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)