Acknowledgements aggregate functions ALL ANY AS keyword ASCII attribute autoincrementable column average value AVG Battles between bibliography C.J.Date calculated columns Cartesian product CASE cast CD drive CHAR CHARINDEX COALESCE collation common table expressions comparison predicates Computer firm CONVERT correlated subqueries Cortazar COUNT COUNT(1) CREATE TABLE CROSS JOIN CTE data type conversion data types DATALENGTH DATEADD DATEDIFF DATENAME DATEPART DBMS DDL DEFAULT DEFAULT VALUES DELETE DENSE_RANK DIFFERENCE DISTINCT DML DML exercises duplicates equi-join escape character EXCEPT exercise 1 exercise 10 exercise 11 exercise 13 exercise 16 exercise 17 exercise 18 exercise 2 exercise 23 exercise 39 exercise 5 exercise 56 exercise 57 exercise 59 exercise 6 exercise 60 exercise 7 exercise 8 exercises 18 EXISTS FLOAT FOREIGN KEY FROM FULL JOIN GROUP BY grouping HAVING Hopscotch IDENTITY IDENTITY_INSERT IN income INITCAP inner join INSERT INTERSECT INTERSECT ALL IS NULL ISNULL J.D.Ullman J.Widom join operations Kalen Delaney laptop LEFT LEFT OUTER JOIN LEN LIKE LOWER LTRIM Martin Gruber MAX MIN mistakes money MySQL NATURAL JOIN NCHAR NOT IN NULL NULLIF number-sequence generation numbering NUMERIC Oracle ORDER BY outcome Outcomes outer joins OVER PARTITION BY PATINDEX PC PIVOT PostgreSQL predicates primary key printer problems and solutions product query console query execution plan RANK Ranking functions recursive CTE Recycled materials company regular expressions relation relational division Relational model renaming columns REPLACE REPLICATE REVERSE RIGHT RIGHT JOIN row constructor ROW_NUMBER RTRIM select SELECT statement self-join SET DATEFIRST SOUNDEX SPACE sql SQL Server SQL Standard SQL-92 sql-ex.ru STR string comparison string functions STUFF subquery substraction SUBSTRING SUM sunken ships tables join teaching sql The order of execution of clauses in SELECT state tips and solutions TOP N WITH TIES trailing spaces Transact-SQL TRUNCATE TABLE tuple type conversion UNICODE UNION UNION ALL uniqueness UNKNOWN UNPIVOT UPDATE UPPER VALUES varchar WHERE wildcard character WITH строковые функции упражнение 23