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

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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!