There are 40 queries that cover a number of topics in SQL, covering data engineering, data science, and database searching. Topics include:

• Retrieving data from single and multiple tables
• Inserting, updating, and deleting data
• Summary queries (aggregate, grouping, summarizing, window, named window, frame functions)
• Joins and subqueries (correlated, uncorrelated, SELECT/FROM/WHERE subqueries, complex, common table expressions)
• Casting, converting, and formatting data types (character, integer, fixed-point, floating-point, date, time, date and time, large objects)
• Date time data types (passing, extracting, date time calculations)
• IF / IF NULL/ COALESCE and CASE statements
• Regular expression functions
• Ranking functions