A data analyst at an ocean conservancy manually recalculates the new column ocean_currents. They want to identify any rows with values that do not match those in the original column, ocean_tides. Which SQL clauses would enable them to do so? Select all that apply.

• WHERE ocean_currents >< ocean_tides

• WHERE ocean_currents != ocean_tides

• WHERE ocean_currents <> ocean_tides

• WHERE ocean_currents !! ocean_tides

Fill in the blank: The SQL command GROUP BY groups table rows with _____ values into summary rows.

• the same

• decreasing

• null

• increasing

What will this spreadsheet function return?

 =SUMIF(K20:K70, ”>=50”, L20:L70)

• The sum of all values in cells L20 to L70 that correspond to values in cells K20 to K70 that are greater than or equal to 50.

• The sum of all values in cells K20 to K70 for which the value in cells L20 to L70 is greater than or equal to 50.

• The count of the number of cells in the array K20:K70 that have a value greater than or equal to 50.

• The sum of any values in cells K20 to K70 and cells L20 to L70 that are greater than or equal to 50.

Which of the following statements accurately describe pivot tables? Select all that apply.

• A pivot table can be used to sort, reorganize, or group data.

• The columns of a pivot table organize and display values vertically.

• The rows of a pivot table organize and display values vertically.

• The filters section of a pivot table is used to apply filters based on specific criteria.

A data analyst at an engineering company calculates the number of spreadsheet rows that contain the value turbine. Which function do they use?

• =COUNTIF(C1:C100,“turbine”)

• \=COUNTIF(C1:C100,turbine)

• \=COUNTIF(turbine=C1:C100)

• \=COUNTIF(C1:C100,“=turbine”)

What is a primary reason data analysts use temporary tables or similar structures (like WITH clauses) when working with SQL?

• To establish universal naming conventions for tables that all database systems recognize automatically.

• To permanently alter the data types of columns in the original source tables.

• To store intermediate results or frequently used subsets of data, making complex queries more manageable and potentially more efficient.

• To automatically ensure that the underlying source data is refreshed in real-time whenever the temporary table is queried.

Which SQL statement will create a temporary table?

• SELECT new_table FROM old_table;

• CREATE TABLE new_table AS ( FROM old_table );

• WITH new_table AS ( SELECT * FROM old_table WHERE z = 5 );

• WITH new_table = ( SELECT * FROM old_table );

Which column is set as a value in this pivot table?

• Time Period

• Type

• MAX

• Month