Online Documentation for SQL Query for SQL Server

Adding a new group

Since we also need to get the list of male specialists-engineers (i.e. those registered in the Engineering and Tool Design departments and having an engineering-oriented position), we can add a complex filter condition combining simple conditions with the AND operator. (However, in this particular case we can just add them on the same root level as for the existing condition).

If you need to add a group of conditions, click the ellipsis button for the HIRE_DATE condition and select the Add Group popup menu item.