lib/Database.js
//not required by the assignment. works correctly, although becasue it is input and not list
not required by the assignment. works correctly, although becasue it is input and not list
not required by the assignment . works correctly although becasue it is input and not list
async viewDeptTeam() {
		const dept = await inquirer.prompt({
			type: 'input',
			name: 'deptChoice',
			message: 'Which department would you like to view?',
			validate: (deptInput) => !!deptInput
		})
		return db.promise().query(`select
				employee.id,
				employee.first_name as 'First Name',
				employee.last_name as Last_Name,
				role.title as 'Title',
				role.salary as 'Salary',
				department.name as 'Department',
				q.last_name AS 'Manager'
			from
				employee
			left join 
				role on employee.role_id = role.id
			left join
				department on role.department_id = department.id 
			left join 
				employee q ON (employee.manager_id = q.id)
			where
				department.name = ?
			order by
				Last_Name;`, dept.deptChoice)
	}
async viewDeptTeam ( ) { const dept = await inquirer . prompt ( { type : 'input' , name : 'deptChoice' , message : 'Which department would you like to view?' , validate : ( deptInput ) => ! ! deptInput } ) return db . promise ( ) . query ( ` ` , dept . deptChoice ) }
not required by the assignment.
not required by the assignment .