Синтаксически корректные запросы SQL: SELECT - Ответ на вопрос по информатике №1158107

Вопрос

• SELECT e.last_name, e.first_name FROM employees e, payroll p WHERE e.salary_id(+) = p.id AND last_name like 'A%';
• SELECT s.title, MIN(start_time) FROM shows s, networks n WHERE s.net_id = n.id AND n.name = 'NBC' GROUP BY s.title;
• SELECT g.description, AVG(b.price) FROM books b WHERE b.book_id = genre.id AND b.author_id = 5 GROUP BY g.description;
• SELECT i.product, i.qty FROM inventory i JOIN RIGHT sales s ON i.id = s.prod_id WHERE s.sales > 10000;
• SELECT s.id, SUM(credit_hrs) FROM students s, classes c WHERE s.id(+) = c.student_id(+) AND c.active = 'Y' GROUP BY s.id;

Ответ