Question

10.
Question 10
Based on the code snippet provided, which part of the code is the subquery?

1234567
SELECT account_table.*
FROM (
SELECT *
FROM transaction.sf_model_feature_2014_01
WHERE day_of_week = 'Monday'
) account_table
WHERE account_table.availability = 'NO'



(

SELECT *

FROM transaction.sf_model_feature_2014_01

WHERE day_of_week = 'Monday'

)



WHERE account_table.availability = 'NO'



SELECT account_table.*



FROM (

SELECT *

FROM transaction.sf_model_feature_2014_01

WHERE day_of_week = 'Monday'

) account_table


1 point

Answer 1

The subquery is the parenthesized block:

(
SELECT *
FROM transaction.sf_model_feature_2014_01
WHERE day_of_week = 'Monday'
) as account_table

—that inner SELECT is the subquery.