Complete SAS Programming Guide - Learn SAS and Become a Data Ninja - WHERE Clause

The video tutorial explains the use of the WHERE clause in SQL, focusing on comparison operators like greater than and equal to. It covers logical operators such as AND and OR, emphasizing the importance of using parentheses to control the order of operations. The tutorial also introduces special operators like CONTAINS and IN for more advanced querying. Examples are provided to illustrate each concept, helping viewers understand how to filter data effectively in SQL.

What is the result of the condition 'pay per hour > 80' if John's pay is 80?

• John is included if he has a bonus

• John is not included

• John is included

• John is included only if he works overtime

Which logical operator is evaluated first if no parentheses are used?

• NOT

• AND

• XOR

• OR

If you want to select employees from departments A or D with a pay of at least 80, which condition is correct?

• department = 'A' OR department = 'D' AND pay >= 80

• department = 'A' OR (department = 'D' AND pay >= 80)

• (department = 'A' OR department = 'D') AND pay >= 80

• department = 'A' AND department = 'D' AND pay >= 80

Why are parentheses important when using logical operators?

• They help in commenting the code

• They change the order of evaluation

• They make the code look cleaner

• They are required for all SQL queries

Which special operator would you use to find names containing a specific sequence of letters?

• IN

• CONTAINS

• BETWEEN

• LIKE

What does the IN operator do?

• Checks if a value is within a range

• Checks if a value matches any value in a list

• Checks if a value is greater than another

• Checks if a value is less than another

Which operator would you use to check if a column value is one of several specified values?

• CONTAINS

• BETWEEN

• LIKE

• IN