Question 5:
n
1
t
Write a query to select EmployeelD, FirstName, LastName, JobTitle, DepartmentName,yearHireDate of all employees whose year of HireDate is in the second quarter of 2004.
Note: the image is only sample output. The result depends on the entered data
Results
Messages
First Name
Last Name
Job Title
Department Name
Shipping
year Hire Date
EmployeeID
133
174
Mallin
Stock Clerk
2004
Jason
Ellen
Abel Sales Representative
Sales
2004
1
2
u
t
or
n
Picture 5.1
Question 6:
Write a query to display LocationID, StreetAddress, City, State Province, CountryID,NumberOfDepartments where NumberOfDepertments is the number of departments in each location; display the results in ascending order of NumberOfDepartment then in descending order of LocationID for locations having the same value of NumberOfDepartments as
+ 100%
p
Di Zoom
e g FUO
Close
