30. Consumers in the ______ age group are more positively disposed towards cinema advertising.

29. The act of discovering hidden facts and relationships contained in databases is called _______.

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 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  

We have done a giveaway to promote our new rewards program. The giveaway was designed to give the postal code with the most activity Elite status while all other postal codes would begin as Standard. Postal code 33111 won our giveaway and we would like to now add the customer status attribute to the customers table. Which of the following queries will accomplish this goal? Note, we are assuming postal code is a character attribute.

Most people with sinus infections can’t smell or taste well.  Explain why smell and taste are affected.        .

Part III: Essay (50 points) Choose one of the following topics and write a terrific, far-reaching essay, one that is rich in critical thought and specific detail. Minimum word count: 500 (“A” essays usually go well beyond the minimum); +1 for a word count. Make sure your essay has an introduction, at least three body paragraphs, and a conclusion. Hint: shorten the intro and conclusion—let the bulk of the paper be the body paragraphs. Bring in numerous specific details from the work, and reference key ideas from class discussion and the PowerPoints in your analysis.   Topic A:  Discuss the Gregor Samsa throughout the three sections of The Metamorphosis.  How does he change/evolve from the beginning of the novella to the end? In your essay, be sure to discuss the following: Gregor in Section I: what is his original reaction to his metamorphosis? How does he slowly realize that life has changed for him?  What challenges does he face?  (One body paragraph) Gregor in Section II: in what ways he is slowly embracing his new insect form? How/where does he still retain aspects of his humanity? (One body paragraph) Gregor in Section III: What is his relationship like with his family? How have things changed?  What is Gregor’s final state?  Note:  You must discuss the scene where Gregor hears Grete playing the violin in detail in this paragraph.  (One body paragraph) **You may expand any one section to two body paragraphs if you choose. Conclusion: What do you think Kafka’s purpose was in creating a character like Gregor Samsa?   Topic B:   Discuss Oedipus as a character whose tragic destiny is shaped by both fate and free will.  In an essay, discuss the following: The events before Oedipus arrived at Thebes to show how he is a pawn of Fate; how does he seem controlled by his destiny, no matter what he does? (One body paragraph) Oedipus as a person whose character flaws—rage, paranoia, etc.– contribute to his demise. How do his actions with Teiresias, Creon, and in particular Laius at the Triple Crossroads reveal those flaws? (One body paragraph) Oedipus’s act of self-punishment. What does he do, and why? How would you characterize his actions here? How does it help us put Oedipus’ character in perspective, for better or for worse?  (One body paragraph) **You may expand any one section to two body paragraphs if you choose. –Conclusion: What kind of character was Sophocles ultimately creating in Oedipus?  

Nearly ______ of Earth’s crust is made up of silicate minerals.

Which type of igneous rock forms from a cooling magma in Earth’s interior?

Which of the following is one of the main outcomes of the Professional Air Traffic Controllers Organization (PATCO) strike?