Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
Get to know the data
2. The Department table
Get to know the OVER() clause
Computations with OVER()
Aggregate functions with OVER()
Using OVER() with WHERE


Okay. Now, let's see what the Department table contains.


Select all the information from the Department table.

This table is extremely simple – it only has two columns: Id and Name.