ill in the blank: To filter for all items in the Products table that are currently in stock, a data professional uses the _____ clause in SQL.1 pointLIMITEXCEPTWHEREFILTER

Fill in the blank: A SQL clause containing HAVING adds a _____ to a query instead of the underlying table.1 pointsubqueryfilterlimitjoin

Which SQL clause is used to filter records?

Question 10What does this code do?1234567SELECT account_table.*   FROM (       SELECT *       FROM transaction.sf_model_feature_2014_01       WHERE day_of_week = 'Monday'       ) AS account_table   WHERE account_table.availability = 'NO'1 pointIt selects all columns from the table containing transactions on Monday and filters them to display only the transactions that are unavailable.It creates a temporary table named account_table containing all transactions from transaction.sf_model_feature_2014_01. It filters the transaction.sf_model_feature_2014_01 table to include only transactions on Fridays. It selects all data from the transaction.sf_model_feature_2014_01 table.

The Oracle WHERE clause: A.Limits the column data that are returned.B.Limits the row data are returned.

The Oracle WHERE clause: A.Limits the column data that are returned.B.Limits the row data are returned