Consider the following $SQ$L query:
With max_balance(value) as Select max(balance) from account;
The result of executing the above query is:
- $A$ temporary table is created with the name $max$_$balance$
- $A$ temporary view is created with the name $max$_$balance$
- $A$ permanent view is created with the name $max$_$balance$
- $A$ permanent table is created with the name $max$_$balance$