This is because an IF function is a type of logical function that returns a value based on a condition or
a set of conditions. An IF function can be used to manipulate data by applying different actions or
calculations depending on whether the condition is true or false. For example, an IF function in Excel
that can achieve this is:
=IF (condition, value_if_true, value_if_false)
The other data manipulation techniques are not examples of logical functions. Here is why:
WHERE is a type of clause that filters data based on a condition or a set of conditions. A WHERE
clause can be used to manipulate data by selecting only the rows that satisfy the condition(s). For
example, a WHERE clause in SQL that can achieve this is:
https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Data+_DA0-001/page_25_img_1.jpg
AGGREGATE is a type of function that performs a calculation on a group of values, such as sum,
average, count, etc. An AGGREGATE function can be used to manipulate data by summarizing or
aggregating the values in a column or a table. For example, an AGGREGATE function in SQL that can
achieve this is:
https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Data+_DA0-001/page_26_img_1.jpg
BOOLEAN is a type of data type that represents two possible values: true or false. A BOOLEAN data
type can be used to manipulate data by storing or returning logical values based on a condition or a
set of conditions. For example, a BOOLEAN data type in Python that can achieve this is:
https://kxbjsyuhceggsyvxdkof.supabase.co/storage/v1/object/public/file-images/Data+_DA0-001/page_26_img_2.jpg
