Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT p.first_name,
- p.last_name,
- e.instituition
- FROM people AS p
- LEFT OUTER JOIN education AS e ON p.id = e.id
- WHERE e.graduated_at IS NOT NULL;
- Соединял по-разному, пробовал без WHERE, все равно не пропускает
- ссылка на задачу
- https://practicum.yandex.ru/trainer/sql-data-analyst/lesson/ce01e9d1-9867-4ecc-8912-e41892e7002f/task/a839cb0e-71c3-4ebe-bcfb-bd35dc0dcd8b/
Advertisement
Add Comment
Please, Sign In to add comment