Question: Retrieve the store ID, title ID, order date, and quantity sold for all sales in 1994 from stores that either sold 20 or more copies
Retrieve the store ID, title ID, order date, and quantity sold for all sales in 1994 from stores that either sold 20 or more copies of a single title or had a payment term of Net 30 days.

This is the code I have and the result.

Columns o stor_id (PK, FK, char(4), not null) o ord num (PK, varchar(20), not null) ord-date (datetime, not null) E qty (smallint, not null) E payterms (varchar(12), not null) title_id (PK, FK, tid(varchar(6)), not null) 1 Eselect stor_id, title_id, ord date, qty 2 from sales 3 where ord_date 1994 and (qty20 or payterms 30); 100 % E Resuits E Results Messages stor id title_id ord_date ty Query executed successfully. (local)lsqlexpress (14.0 RTM) MSIVEricR (52) pubs 00:00:00 0 rows
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
