andrey_vetrov

project_11

Apr 10th, 2022 (edited)
28
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.45 KB | None | 0 0
  1. SELECT p.first_name,
  2. p.last_name,
  3. e.instituition
  4. FROM people AS p
  5. LEFT OUTER JOIN education AS e ON p.id = e.id
  6. WHERE e.graduated_at IS NOT NULL;
  7.  
  8.  
  9. Соединял по-разному, пробовал без WHERE, все равно не пропускает
  10.  
  11. ссылка на задачу
  12.  
  13. 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