Select as subquery

> *Option:*  **fmt033_subquery_start_parenthesis_in_newline** = **true**, type: **TFmtBoolean**.

> *Option:*  **fmt034_subquery_start_parenthesis_indent** = **n**, type: **TFmtBoolean**.

> *Option:*  **fmt037_subquery_select_keyword_in_newline** = **true**, type: **TFmtBoolean**.

> *Option:*  **fmt038_subquery_select_keyword_indent** = **n**, type: **TFmtBoolean**.

> *Option:*  **fmt035_subquery_end_parenthesis_in_newline** = **true**, type: **TFmtBoolean**.

> *Option:*  **fmt036_subquery_end_parenthesis_indent** = **n**, type: **TFmtBoolean**.

```SQL
SELECT SUM (Sales) FROM Store_Information
WHERE Store_Name IN 
       (
         SELECT Store_Name FROM Geography
         WHERE Region_Name = 'West'
       );
```

• Put comparison operator after subquery into new line

  SELECT [CategoryID] AS [CategoryId], 
  FROM   [dbo].[Categories] 
  WHERE  (SELECT Sum([LPA_L1].[UnitsInStock]) AS [LPAV_] 
               FROM   (SELECT [CategoryID] AS [CategoryId], 
                       FROM   [dbo].[Products] 
                       WHERE  [Products].[CategoryID] 
                            = [Categories].[CategoryID] ) [LPA_L1])
         > @p2