create A query that is based on two tables and includes both an arithmetic and a

Question

create A query that is based on two tables and includes both an arithmetic and a special operator in the conditional expression.

mysql> SELECT FROM CUSTOMERI ORDER: I CUS l ORDER ID I CUS l ORDERDATE I CUSTl ORDER TIME I CUS l ID I 2006 l 2015-09-03 00:00:00. 000000 l ll: 30:00. 000000 29993 l 2344 l 2016-03-24 00:00:00.000000 l 12: 45:00. 000000 83028 l 2454 I 0016-01-09 00:00:00.000000 l ll: 30:00. 000000 43874 l 2568 l 2016-09-26 00:00:00.000000 l 09:00:00. 000000 28037 I 2695 l 2016-02-14 00:00:00. 000000 l 08:00:00.000000 91074 I 5 rows in set (0.00 sec) mysgl> JORDANE METENOUI

Explanation / Answer

SELECT custi_id, custi_order_time FROM customer; SELECT 2*35 FROM DUAL; SELECT custi_id + 1500 FROM customer; SELECT 'ORACLE'||' CERTIFICATION' FROM dual; SELECT first_name ||'earns'|| salary||' as of '|||sysdate FROM employees; SELECT NULL + 1000 NUM FROM DUAL;

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.