Question: 4. Create a new query named: GreenhouseTechsFT a. Add all the fields from the Employees table b) The query should list all employees whose Position

4. Create a new query named: GreenhouseTechsFT a. Add all the fields from the Employees table b) The query should list all employees whose Position begins with the word greenhouse and whose weekly hours are greater than or equal to 20 . Hint: Include a widoard character in the criterion for the Position field. Modify the query design so results are sorted alphabetically by last name. Add the Maintenance Log table to this query and inglude the MaintenanceDate field after the WeeklyHlours field
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
