Nested Queries | SQL | Tutorial 18




Giraffe Academy is rebranding! I’ve decided to re-focus the brand of this channel to highlight myself as a developer and teacher! The newly minted Mike Dane …

Original source


10 responses to “Nested Queries | SQL | Tutorial 18”

  1. i'm making an ecommerce website already made a db for it, but we are expanding so the nested model sounds like the best solution due to the filters and all that, but after watching this and making those huge queries (not difficult tho, just thinking about the whole mantainance and all the what would happen ifs), i feel like hierarchy model could be better, (can't work with mongodb since our hosting doesn't support it), what do you recommend me?

  2. SELECT employee.first_name, employee.last_name
    FROM employee
    WHERE employee.emp_id IN (
    SELECT works_with.emp_id
    FROM works_with
    )
    AND employee.branch_id = 2;

    This brings up only Stanley Hudson while it should bring up 4 other people? Could you please explain this

  3. hello, i have a question: the first exercise is trying to get employees whose total sales are for a SINGLE CLIENT, right? what if i wanted to list their total sales for all clients? Please help! :/ ps. very useful videos

Leave a Reply