New Discussion

Notifications

You’re not receiving notifications from this thread.

SQL Learning Path - Having Statements Discussion

6
General

I have a question about replacing store_id with stores.name if we add JOIN to the query (4:50 for example). Would it be valid replacement if there are multiple stores with the same name but obviously with different ids? Can we replace store_id with stores.id instead? Thanks

Hey Collin, just want to say thanks for this resource. Learning a ton 💪

Hey Avery! This comment made my day. I’m super glad to hear that you’re finding it useful! 😀

Collin, terrific course. I used it as a refresher and found it thorough, detailed, and frankly, fun. Appreciate your hard work. These videos take a long time to plan out. A++. Thank you.
I'll be using this as part of my Ruby on Rails training as I will be making use of the built-in API functions that interact with the Postgres database.

Hi, the products table only had one product with a discount above 20% but the query returned 3 as the count? Is it that the query is not specifically looking for those rows with a discount above 20%. It just returns the count of all products?

Thanks for this nice course) I hope you will continue this work and record advanced level of SQL

Thanks for the kind words, Vladholovchak! Glad you enjoyed it, I'd love to add onto this course with some more intermediate and advanced content in the future!

Join the discussion
Create an account Log in

Want to stay up-to-date with Ruby on Rails?

Join 91,696+ developers who get early access to new tutorials, screencasts, articles, and more.

    We care about the protection of your data. Read our Privacy Policy.