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.

Question 6Fill in the blank: The SQL clause SELECT * is used to retrieve all data from a particular _____.

___________ clause is used to retrieve data from one or more tables?Select one:WhereOrder bySelectHaving

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?

In the SQL statement above, what does * indicate?Group of answer choicesIt indicates nothingIt indicates to extract none of the fields from the table to a queryIt indicates to extract * from the table to a queryIt indicates to extract all the fields from the table to a query