Exercise #2 (tips and solutions)

HAVING head ships IDENTITY IN income inner join INSERT INTERSECT ISNULL join operations laptop launched year LEFT LEFT OUTER JOIN LEN LTRIM MAX MIN mistakes MySQL NOT IN NULL number sequences number-sequence generation numbering ORDER BY outcome Outcomes outer joins OVER paging PARTITION BY PATINDEX PC PIVOT PostgreSQL predicates printer product Ranking functions recursive CTE REPLACE RIGHT ROW_NUMBER ships SQL Server SQL-92 sql-ex.ru string functions subquery SUBSTRING tables join tips and solutions Torus Transact-SQL type conversion UNION UNION ALL UNKNOWN UPDATE varchar WHERE window functions WITH упражнение 23