ALL ANY ASCII AVG Battles C.J.Date Cartesian product CASE cast CHAR CHARINDEX COALESCE collation common table expressions comparison predicates CONVERT correlated subqueries COUNT CROSS JOIN CTE data type conversion DATEADD DATEDIFF DATENAME DATEPART DELETE DISTINCT DML DML exercises equi-join escape character EXCEPT exercise 10 exercise 11 exercise 17 exercise 2 exercise 23 exercise 39 exercise 56 exercise 57 exercise 59 exercise 6 exercise 60 exercise 7 exercise 8 EXISTS FROM FULL JOIN GROUP BY HAVING IDENTITY IN inner join INSERT INTERSECT ISNULL J.D.Ullman J.Widom join operations laptop LEFT LEFT OUTER JOIN LEN LIKE LOWER LTRIM Martin Gruber mistakes MySQL NULL numbering Oracle ORDER BY Outcomes OVER PARTITION BY PATINDEX PC PIVOT PostgreSQL predicates printer product Ranking functions recursive CTE REPLACE REPLICATE RIGHT RIGHT JOIN ROW_NUMBER select SQL Server STR string functions subquery SUBSTRING SUM tables join tips and solutions Transact-SQL type conversion UNION UNION ALL UNKNOWN UNPIVOT UPDATE UPPER varchar WHERE WITH упражнение 23