Codes from SQL lessons which I participated in from September to December 2023.
-
select, from, where, group by + having, order by, data types
- homework
-
cast vs ::, where (conditions - >, <, =, ==, in), agregation, group by
- homework
-
string functions (split, lenght, replace, substring, left, right, upper, charindex, possition), select distinct, math functions (haversine, round, floor, ceil, trunc), date functions (to_date, date_from_parts, dateadd, dateiff, extract), ifnull, case when, like, ilike,
- homework
-
joins (inner, left, right, full, cross),
- homework
-
subselect in select, subselect in condition, subselect in from
-
repetition of joins, temporary table, CTE, subselect
-
repetition of temporary tables, CTEs, subselects, union, union all, window functions aggregation(count() over (), sum() over (), max() over (), min() over (), avg() over ()) partititon by qualify row_number(), rank() window function + group by
- homework
-
uniform, generator, cross join, sequence,
-
a) creating the first temporary table with titles * and ratings averageratings and numvotes + 2. converting titletype to titletype_new b) connectiong all tables into one 'netflix_imdb' c) how many duplicates are in the result?