(Solved) : Activity Using Adventureworks Database Link Download Sample Database Needed Https Archivec Q30342854 . . . .

For this activity, we will using the AdventureWorksdatabase.

(Here is the link to download the sample database if needed.https://archive.codeplex.com/?p=msftdbprodsamples

Select the oltp file)

–Query 1–Who is the most senior employee in eachdepartment?–List the employee who first started working in eachdepartment. Use the– start date in the Department to determine whostarted in the department– first. Only include employees that arestill working for the company.– Include first and last name ofemployee, name of department, and date– started in department.–If there is more than one employee that started in a department onthe– earliest startdate, list them both. Order the list inalphabetical order– by department.

Expert

OR

 

PayPal Gateway not configured

OR

 

PayPal Gateway not configured