展示品を見て、STORES テーブルの構造を調べてください。STORES テーブル NameNull?Type ---------------------- ------------- STORE_IDNUMBER NAMEVARCHAR2(100) ADDRESSVARCHAR2(200) CITYVARCHAR2(100) COUNTRYVARCHAR2(100) START_DATEDATE END_DATEDATE PROPERTY_PRICENUMBER ADDRESS、START_DATE、PROPERTY_PRICE、予想物件価格(物件価格の 115%)とともに、店舗の NAME を表示したい。表示される店舗は、START_DATEが以下の期間から36ヶ月の範囲内である必要があります。
A. SELECT name, concat (address| |', |city| |', ', country) AS full_address,start_date,property_price, property_price*115/100FROM storesWHERE MONTHS_BETWEEN (start_date, '01-JAN-2000')<=36;
B. SELECT name, concat (address| |', |city| |', ', country) AS full_address,start_date,property_price, property_price*115/100FROM storesWHERETO_NUMBER(start_date-TO_DATE('01-JAN-2000','DD-MON-RRRR'))
C. SELECT name, address||','||city||','||country AS full_address,start_date,property_price, property_price*115/100FROM storesWHERE MONTHS_BETWEEN (start_date, TO_DATE('01-JAN-2000','DD-MON-RRRR'))
D. SELECT name, concat (address||','|city||', ', country) AS full_address,start_date,property_price, property_price*115/100FROM storesWHERE MONTHS_BETWEEN (start_date, TO_DATE('01-JAN-2000','DD-MON-RRRR'))<=36;