Exercises 1.txt

1. Find the name of all departments currently managed by women.
	Department Name | Manager Name
	----------------+-----------------
	Development     | Leon DasSarma
	Finance         | Isamu Legleitner
	Human Resources | Karsetn Sigstam
	Research        | Hilary Kambil

2. Find the current titles of employees currently working in the Customer Service department.
	Title              | Count
	-------------------+------
	Assistant Engineer |    68
	Engineer           |   627
	Manager            |     1
	Senior Engineer    |  1790
	Senior Staff       | 11268
	Staff              |  3574
	Technique Leader   |   241

3. Find the current salary of all current managers.
	Department Name    | Name              | Salary
	-------------------+-------------------+-------
	Customer Service   | Yuchang Weedman   |  58745
	Development        | Leon DasSarma     |  74510
	Finance            | Isamu Legleitner  |  83457
	Human Resources    | Karsten Sigstam   |  65400
	Marketing          | Vishwani Minakawa | 106491
	Production         | Oscar Ghazalie    |  56654
	Quality Management | Dung Pesch        |  72876
	Research           | Hilary Kambil     |  79393
	Sales              | Hauke Zhang       | 101987

4. Find the names of all current employees, their department name, and their current manager's name.
   (Table and column aliases are ESSENTIAL for this one)
	240,124 Rows