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.

Retrieve the store ID, title ID, order date, and quantity sold for

This is the code I have and the result.

all sales in 1994 from stores that either sold 20 or more

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

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!