回答編集履歴
1
修正
test
CHANGED
|
@@ -6,11 +6,19 @@
|
|
|
6
6
|
|
|
7
7
|
|
|
8
8
|
|
|
9
|
-
SUM('みかん'+'りんご'+'ばなな')
|
|
9
|
+
SELECT * FROM fruits_price WHERE SUM('みかん'+'りんご'+'ばなな') > 600
|
|
10
10
|
|
|
11
11
|
↓
|
|
12
12
|
|
|
13
|
-
みかん + りんご + ばなな
|
|
13
|
+
SELECT * FROM fruits_price WHERE みかん + りんご + ばなな > 600
|
|
14
|
+
|
|
15
|
+
|
|
16
|
+
|
|
17
|
+
↓ 更に変更
|
|
18
|
+
|
|
19
|
+
|
|
20
|
+
|
|
21
|
+
SELECT * FROM fruits_price WHERE TO_NUMBER(みかん) + TO_NUMBER(りんご) + TO_NUMBER(ばなな) > 600
|
|
14
22
|
|
|
15
23
|
```
|
|
16
24
|
|