Acknowledgements AGE aggregate functions Airport ALL ANSI_NULLS ANY AS keyword ASCII attribute autoincrementable column average value AVG balloon Battles between Bezhaev bibliography Bismarck C.J.Date calculated columns Cartesian product CASE cast CD drive CHAR CHARACTER STRING CHARINDEX check constraint classes COALESCE collation common table expressions Company comparison predicates Computer firm CONVERT correlated subqueries Cortazar COUNT COUNT(1) CREATE TABLE CROSS JOIN CTE data type conversion data types database schema DATALENGTH date/time functions DATEADD DATEDIFF DATENAME DATEPART DATETIME DATE_PART DBMS DDL DECIMAL DEFAULT DEFAULT VALUES DELETE DENSE_RANK DIFFERENCE DISTINCT DML DML exercises domain duplicates E.F.Codd EPOCH equations root equi-join escape character EXCEPT EXEC exercise (-2) exercise 1 exercise 10 exercise 11 exercise 13 exercise 15 exercise 16 exercise 17 exercise 18 exercise 19 exercise 2 exercise 23 exercise 24 exercise 25 exercise 26 exercise 27 exercise 30 exercise 37 exercise 38 exercise 39 exercise 43 exercise 46 exercise 5 exercise 51 exercise 53 exercise 54 exercise 55 exercise 56 exercise 57 exercise 59 exercise 6 exercise 60 exercise 7 exercise 70 exercise 71 exercise 8 exercises exercises 18 EXISTS EXTRACT FLOAT FOREIGN KEY FROM FULL JOIN GROUP BY grouping Guadalcanal HAVING head ships Hopscotch IDENTITY IDENTITY_INSERT IN income income_o INITCAP inner join INSERT INTERSECT INTERSECT ALL INTERVAL IS NOT NULL IS NULL ISNULL J. Celko J.D.Ullman J.Widom Joe Celko join operations Kalen Delaney laptop launched year learning stage LEFT LEFT OUTER JOIN LEN LIKE LIMIT Lorus LOWER LTRIM maker Martin Gruber MAX Mercadot MIN MINUTE mistakes money MONTH MySQL NATURAL JOIN NCHAR NEWID NOT EXISTS NOT IN NULL NULLIF number sequences number-sequence generation numbering NUMERIC Oracle ORDER BY outcome Outcomes outcome_o outer joins OVER paging Painting PARTITION BY Passenger Pass_in_trip PATINDEX PC PIVOT PostgreSQL predicates primary key printer problems and solutions product query console query execution plan query optimization RAND random sampling of rows RANK Ranking functions recursive CTE recycled materials Recycled materials company regular expressions relation relational division Relational model renaming columns REPLACE REPLICATE REVERSE RIGHT RIGHT JOIN RND ROUND rounding row constructor ROW_NUMBER RTRIM running totals select SELECT statement self-join SET DATEFIRST ships SOUNDEX SPACE sql SQL Server SQL Server 2000 SQL Standard SQL-92 sql-ex.ru stored procedure 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 Three-valued logic TIMESTAMP TIMESTAMPDIFF tips and solutions TOP N WITH TIES Torus TO_CHAR trailing spaces Transact-SQL Trip TRUNCATE TABLE tuple type conversion typical problems UNICODE UNION UNION ALL uniqueness UNKNOWN UNPIVOT UPDATE UPPER utB utQ utV VALUES varchar WHERE wildcard character window functions WITH YEAR строковые функции упражнение 23