27. Which of the following is a major problem with direct mail?
16. Which is the most expensive daypart for advertising on r…
16. Which is the most expensive daypart for advertising on radio?
21. When a national television advertiser places ads in sele…
21. When a national television advertiser places ads in select geographic markets, this is termed _____.
9. One of the keys to success of the informercial is _______…
9. One of the keys to success of the informercial is ____________.
24. _________ advertising involves the use of any of several…
24. _________ advertising involves the use of any of several media to transmit messages that encourage buyers to purchase directly from the advertiser.
42. Perky Print is a commercial printer in Omaha that has ju…
42. Perky Print is a commercial printer in Omaha that has just started to advertise. Fifty percent of its target audience was exposed one or more times to Perky Print’s advertisements during an established time frame. Fifty (50) is the _____ for Perky Print.
30. Consumers in the ______ age group are more positively di…
30. Consumers in the ______ age group are more positively disposed towards cinema advertising.
29. The act of discovering hidden facts and relationships co…
29. The act of discovering hidden facts and relationships contained in databases is called _______.
Write a query to retrieve the sales amounts from transaction…
Write a query to retrieve the sales amounts from transactions made at dealerships located in the state of Florida. Fill in the blank: SELECT s.sales_amount, s.dealership_id, d.dealership_id , d.state FROM saletransactions AS sINNER JOIN ( SELECT __(1)___ FROM dealershipinfo WHERE state=’FL’ ) AS dON __________(2)____________ ;
Suppose you have a database containing the following two sma…
Suppose you have a database containing the following two small tables: table name: customers customer_id customer_name membership 1 Bob basic 2 Larry basic 3 Judy elite 4 Doug elite 5 Rachel basic table name: transactions, transaction_id customer_id transaction_date transaction_amount 1 3 ‘2018-04-01’ 478.02 2 3 ‘2018-05-15’ 15.11 3 4 ‘2018-06-01’ 167.89 4 4 ‘2018-06-01’ 1004.21 5 4 ‘2018-07-04’ 452.52 6 1 ‘2018-08-21’ 19.01 Which of the following SQL queries returns the output below (Make sure the column names match the above table as well): customer_id transaction_id customer_name transaction_date transaction_amount 3 1 Judy ‘2018-04-01’ 478.02 4 3 Doug ‘2018-05-01’ 167.89 4 4 Doug ‘2018-06-01’ 1004.21 4 5 Doug ‘2018-07-04’ 452.52