回答編集履歴
1
推敲
answer
CHANGED
|
@@ -5,5 +5,8 @@
|
|
|
5
5
|
s_date as (
|
|
6
6
|
select date("2021-03-17") as s_date_value
|
|
7
7
|
)
|
|
8
|
+
, dateadd as (
|
|
8
|
-
select DATE_ADD(s_date_value, INTERVAL 149 DAY) from s_date
|
|
9
|
+
select DATE_ADD(s_date_value, INTERVAL 149 DAY) as dateadd_value from s_date
|
|
10
|
+
)
|
|
11
|
+
select * from dateadd
|
|
9
12
|
```
|