Comments (10)
Paul Buffa
Jun 27, 2023Since we only want perfect matches for this, you can remove the LEFT JOIN and just use a JOIN. LEFT JOINs should only be used when you're expecting null values, and here there's always a record in each of these tables for an order.
Paul Buffa
Jun 27, 2023great!
Paul Buffa
Jun 27, 2023Filter looks good! Same comment before on LEFT JOIN vs JOIN
Paul Buffa
Jun 27, 2023I'm getting an error on this one, as I think it's trying to do too much at once. I'd use the product.Launch date instead of the orders.orderDate, as the latter will make the query much slower.
The query looks fine to me, just needs to swap out those dates.
Paul Buffa
Jun 27, 2023Very good! Only thing is you can remove the LEFT JOIN and just use a JOIN.
Jun 27, 2023
Overall you did a great job on all the prompts. Good work! You've completed the assignment. We'll send over the certificate to you soon.
Fotis Zapantis
Aug 21, 2023Hi Paul, I don't seem to have received this certificate can you please resend to zapantisf@gmail.com?
Paul Buffa
Aug 21, 2023Hey Fotis - do you mind checking your spam folder first? We heard from a few people that it went there.
Fotis Zapantis
Aug 27, 2023Hi Paul - I have checked the spam folder and I can't find anything ... can you please resend?
Paul Buffa
Aug 29, 2023Hey Fotis - ok! We just resent. If its not in your inbox, I'd check spam again. We're working to resolve this issue, but it could still get sent there.