1) Select the ClientName, ProjectStartDate, and TaskID fields for all records that have a project start date in the year 2020 and have a task ID of MEET00 or MEET01. Sort the records by client name then task ID.

2) An employee of JC Consulting created the query shown in Figure 2-48. He wants to list the client name, project ID, and task description for each task assigned to the projects for that client. Will this query be successful? If not, what needs to change in order for this query to work correctly?

Figure 2-48 Query to Select the Client Name, Project ID, and Description Query1 Clients Projects Task Master List Clienti ClientName Street Zip Government Projectio ProjectStartDate Clienti EmployeeID ProjectNotes TaskID Description CategoryID Per Estimate ProjectID Projects Description Task MasterList Field ClientName Table Clients Sort Show Criteria or