In Oracle's flavor of SQL, "dual is just a convienence table". It was originally intended to double rows via a JOIN, but now contains one row with a DUMMY value of 'X'.
List employees earning more than $50000 born this century. List their name, date of birth and salary, sorted alphabetically by name.
Show the number of employees in each department with at least 5 employees. List the largest departments first.