Tags$Edge_id 1$From_id 1$Node_id 1$To_id 11900-01-01 1Acknowledgements 1AGE 1Aggregate Functions 6Airport 5ALL 6ALTER TABLE 2AND 1ANSI_NULLS 1ANY 2AS Keyword 1ASCII 3Attribute 1AUTO_INCREMENT 2Autoincrementable Column 1Average Value 2AVG 11Balloon 1Battles 5Ben-Gan 1Between 2Bezhaev 3Bibliography 1Bismarck 4BOOLEAN 1C.J.Date 3Calculated Columns 1Cartesian Product 7CASCADE 1CASE 11Cast 5CD Drive 1CEILING 2CHAR 5CHARACTER STRING 1CHARINDEX 4Chebykin 1Check Constraint 6Classes 5COALESCE 5Collation 2Common Table Expressions 3Company 2Comparison Predicates 4Composite Intervals 1Computer Firm 6CONCAT 2CONCAT_WS 1CONSTRAINT 2CONTINUE IDENTITY 1CONVERT 5Correlated Subqueries 11Cortazar 1COUNT 8COUNT(1) 1CREATE FUNCTION 1CREATE SEQUENCE 1CREATE TABLE 2CROSS APPLY 3CROSS JOIN 2CROSSTAB 1CTE 5Current_timestamp 1Cypher 2Data Type Conversion 7Data Types 4Database Schema 6DATALENGTH 1DATE_ADD 1DATE_FORMAT 1DATE_PART 1Date_time Functions 5DATEADD 4DATEDIFF 2DATEFROMPARTS 1DATENAME 3DATEPART 5DATETIME 5DBMS 1DDL 3DECIMAL 1DEFAULT 4DEFAULT VALUES 2DELETE 5Delimited Identifier 1DENSE_RANK 1DIFFERENCE 1DISTINCT 7DIV 1DML 4DML Exercises 2Domain 1DROP TABLE 1Duplicates 5E.F.Codd 2Edge 3Entity Integrity 1EOMONTH 1EPOCH 1Equations Root 1Equi-Join 3Escape Character 1EXCEPT 4EXEC 1Exercise (-2) 2Exercise 1 1Exercise 10 2Exercise 11 2Exercise 13 1Exercise 15 2Exercise 16 2Exercise 17 2Exercise 18 1Exercise 19 1Exercise 2 2Exercise 23 2Exercise 24 1Exercise 25 1Exercise 26 2Exercise 27 2Exercise 3 (Rating) 1Exercise 30 2Exercise 32 1Exercise 37 2Exercise 38 1Exercise 39 2Exercise 43 1Exercise 46 2Exercise 5 1Exercise 51 1Exercise 53 2Exercise 54 2Exercise 55 2Exercise 56 2Exercise 57 2Exercise 59 2Exercise 6 2Exercise 60 2Exercise 7 2Exercise 70 2Exercise 71 1Exercise 77 1Exercise 78 1Exercise 8 2Exercise 93 1Exercises 2Exercises 18 1Exist 1EXISTS 6EXP 2EXTRACT 2Factorial 1FETCH 1Fibonacci Sequence 1First Day of the Week 1FLOAT 4FLOOR 2FOREIGN KEY 2FROM 5FULL JOIN 5Generate_series 1Graph 2Graph Data Model 1Graph DBMS 1GROUP BY 10GROUP_CONCAT 1Grouping 6Guadalcanal 2HAVING 8Head Ships 4Hopscotch 1IDENTITY 3IDENTITY_INSERT 2IIF 1IN 6Income 3Income_o 1INFORMATION_SCHEMA 3INITCAP 1Inner Join 5INSERT 6INTEGER 1Integer Division 1INTERSECT 3INTERSECT ALL 1INTERVAL 2IS NOT NULL 4IS NULL 5ISNULL 4Itzik Ben-Gan 2J. Celko 1J.D.Ullman 2J.Widom 2Joe Celko 1Join Operations 3JSON 1Kalen Delaney 1LAG 2Laptop 7Launched Year 2LEAD 2Leap Year 1Learning Stage 1Least-Square Method 1LEFT 4LEFT OUTER JOIN 7LEN 6LIKE 2LIMIT 2LOG 2LOG10 1Logical Operators 1Lorus 1LOWER 2LTRIM 2Maker 2Martin Gruber 2MATCH 1MAX 7Mercadot 1MERGE 1MIN 2MINUS 1MINUTE 1Mistakes 44MOD 1Modify 1Money 3MONTH 2MySQL 22NATURAL JOIN 2NCHAR 1NEWID 1NO ACTION 1Node 3Nodes 1NoSQL 1NOT 1NOT EXISTS 2NOT IN 3NTILE 1NULL 18NULLIF 3NULLS FIRST 1NULLS LAST 1Number Sequences 1Number-Sequence Generation 2Numbering 4NUMERIC 2OFFSET 2ON DELETE CASCADE 2OR 1Oracle 9ORDER BY 8Outcome 4Outcome_o 2Outcomes 11OUTER APPLY 1Outer Joins 5OUTPUT 1OVER 8Paging 1Painting 5PARTITION BY 6Pass_in_trip 4Passenger 2PATINDEX 2PC 15PIVOT 4PostgreSQL 18POWER 2PRECEDING 1Predicates 5Primary Key 3Printer 7Problems and Solutions 1Product 9Query 2Query Console 1Query Execution Plan 2Query Optimization 1Query Variables 1QUOTED_IDENTIFIER 1RAND 1Random Sampling of Rows 1RANGE 1RANK 1Ranking Functions 5Recursive CTE 4Recycled Materials 2Recycled Materials Company 2Reference Integrity 1REFERENCES 1Regular Expressions 1Relation 2Relational Division 2Relational Model 1Relationship 1Remainder of Division 1Renaming Columns 1REPLACE 3REPLICATE 2RESTART IDENTITY 1REVERSE 1RIGHT 3RIGHT JOIN 2RND 1ROLLUP 1ROUND 4Rounding 3Row Constructor 1ROW_NUMBER 6ROWNUM 1RTRIM 1Running Totals 1Select 2SELECT Statement 1Self-Join 2SERIAL 1SET DATEFIRST 2SET LANGUAGE 1SET NULL 1Ships 18Sorting 3SOUNDEX 1SPACE 1Splitting Strings 1Sql 2SQL Server 9SQL Server 2000 1SQL Server 2012 3SQL Server 2017 1SQL Standard 1SQL-92 6Sql-Ex.ru 5SQRT 1Stored Procedure 1STR 2String Comparison 1String Functions 15STRING_AGG 2STRING_SPLIT 1STUFF 1Subquery 12Substraction 1SUBSTRING 3SUM 3Sunken Ships 1Table Constructor 2Tables Join 2Teaching Sql 1The Order of Execution of Clauses in SELECT State 1Three-Valued Logic 1Time Intervals 1TIMEFROMPARTS 1TIMESTAMP 1TIMESTAMPDIFF 1TINYINT 1Tips and Solutions 27TO_CHAR 2TOP N WITH TIES 2Torus 2Trailing Spaces 1Transact-SQL 3Trip 4TRUNCATE TABLE 1Tuple 1Type Conversion 3Typical Problems 1UDF 1UNBOUNDED 1UNICODE 1UNION 18UNION ALL 9UNION JOIN 1UNIQUE 1Uniqueness 2UNKNOWN 4UNPIVOT 2UPDATE 5UPPER 2USING 1UtB 2UtQ 2UtV 2Value 1VALUES 2Varchar 7VARCHAR(MAX) 1WHEN MATCHED 1WHERE 7Wildcard Character 1Window Functions 8WITH 2WITH TIES 1WITH VALUES 1WITHIN_GROUP 1XML 1XPath 1XQuery 1YEAR 1