Which of the following will display all books that were published at least three years before they were ordered?
a. SELECT titleFROM customers NATURAL JOIN ordersNATURAL JOIN orderitems NATURAL JOIN booksWHERE orderdate - pubdate >= 3;
b. SELECT titleFROM orders o, orderitems oi, books bWHERE b.isbn = oi.isbn AND oi.order# = o.order#AND orderdate - pubdate >= 3;
c. SELECT titleFROM orders o, orderitems oi, books bWHERE b.isbn = oi.isbn AND oi.order# = o.order#AND (orderdate-pubdate)/365 >= 3;
d. none of the above
c
You might also like to view...
Disseminating unpaid news items through some form of media to gain attention or support is referred to as
A. publicity. B. sales promotion. C. free advertising. D. media-controlled content. E. public relations.
Paul and Diana are married and own a home. Both of their names are on the mortgage. This is an example of A)?a tenancy in kind
B)?a tenancy at will. C)?a concurrent estate. D)?a share estate.
Which of the following is a valid difference between a password and user name?
A) A password is used to encode information, whereas a user name is used to decode information. B) Unlike a password, a user name is more complex. C) A user name identifies the user, whereas a password authenticates the user. D) A user name is common among users, whereas a password is unique.
Customer relationship management (CRM) helps firms gain competitive advantage by all of the following EXCEPT:
a. by providing real-time transaction processing. b. by segmenting markets based on demographic and behavioral characteristics c. by tracking sales trends and advertising effectiveness. d. by identifying which customers should be the focus of targeted marketing initiatives.