Question: What do the below SQL statements mean? Explain each query in a few steps.ALTER TABLE LINEITEMS MODIFY Quantity CHECK ( Quantity > 0 ) ;

What do the below SQL statements mean? Explain each query in a few steps.ALTER TABLE LINEITEMS
MODIFY Quantity CHECK (Quantity >0);
Makoto Nakayama, Ph.D.2/4
o SELECT ORDERS.salesman_id, EMPLOYEES.last_name,
EMPLOYEES.first_name FROM ORDERS
INNER JOIN EMPLOYEES
ON EMPLOYEES.employee_id=ORDERS.salesman_id;
o SELECT * FROM ORDERS
WHERE EXTRACT(year FROM order_date)=2017;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!