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

Question 6Fill in the blank: A SQL clause containing HAVING allows you to add a filter to your query when working with _____ functions.1 pointORDER BYGROUP BYaggregatejoin

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

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.

What is the purpose of the SQL HAVING clause?OptionsTo join two or more tablesTo sort rows in a tableTo filter rows from a tableTo filter rows after grouping