Chapter four: extra exercises
eLast, eFirst, eTitle, eSalary
aTitle, aURL, aLeadID
cTitle, cHours, areaID
tYear, tMonth, tDay
What training courses are offered in the 'Database' technology area?
Which employees have taken a training course offered in the 'Database' technology area?
Which employees have not taken any training course?
Which employees took courses in more than one technology area?
Which employees have the minimum salary?
Which employees took all of the training courses offered in the 'Database' technology area?
Display the last names of the employees in alphabetical order and within that display their salary in descending order.
Display the minimum, maximum and average employee salary, as well as the sum of all salaries and a count of the number of employees in the database.
Give the number of employees that took a training course in the database technology area.
Display the minimum, maximum and average employee salary of employees by title.
Display the identification number of the technology area, its title and the number of employees.
Display the areas with at least 4 employees that took training courses in that technology area and display the result in descending order on the number of employees.