Deviopath › PostgreSQL

Well-Paid Sales and Support

Easy · Filtering

= checks that two values are equal (<> checks that they differ). Text values go in single quotes, like 'Sales', and the comparison is case-sensitive. Combine conditions with AND (both must be true) and OR (at least one must be true). AND is applied before OR, so use parentheses to group an OR.

Return the first_name, department and salary of employees who work in 'Sales' or 'Support' and earn at least 50000.

Next: Customers in Two Cities