...Return only those rows where the count of the line items is greater than 1. This should return 10 rows. c. Group the result set by account descriptions. d. Sort the result set in descending sequence by the sum of the line item amounts. Answer: SELECT account_description, COUN T(*) AS line_item_count, SUM (line_item_amt) AS line_item_amt_sum FROM general_ledger_accounts gl JOIN invoice_line_items li ON gl.account_number = li.account_number GROUP BY gl.account_description HAVING COUNT (*) > 1 ORDER BY line_item_amt_sum DESC 5. Modify the solution to exercise 4 so it returns only invoices date in the second quarter of 2014 (April 1, 2014 to June 30, 2014). This should still return 10 rows but with some different line item counts for each vendor. Hint: Join to the Invoices table to code a search condition base on invoice_date. Answer: SELECT account_description...
Words: 539 - Pages: 3
...variable naming rules for VB are: o Must be one word, no spaces o Punctuation characters are avoided o The character cannot be a number o Name a variable something that indicates what may be stored in it o camelCase can be used Python Variable Naming Rules: o Must begin with a letter (a - z, A - B) or underscore (_). o Other characters can be letters, numbers or _ only. o Variable names are Case Sensitive. o There are some reserved words which we cannot use as a variable name because Python uses them for other things. These are :and,del,from,not,while,as,elif,global,or,with,assert,else,if,pass,yield,break,except,import,print,break,except,import, print,class,exec,in,raise,class,exec,in,raise,continue,finally,is,return,continue,finally,is,return,def,for,lambda . http://www.programmr.com/index.php?q=python-variable-naming-rules o Variable names are case-sensitive. A variable's name can be any legal identifier — an unlimited-length sequence of Unicode letters and digits, beginning with a letter, the dollar sign "$", or the underscore character "_". The convention, however, is to always begin your variable names with a letter, not "$" or "_". Additionally, the dollar sign character, by convention, is never used at all. You may find some situations where auto-generated names will contain the dollar sign, but your variable names should always avoid using it. A similar convention exists for the underscore character;...
Words: 564 - Pages: 3
...Case: What’s in names? According to sociologists and name researchers parents are spending more time and money to find perfect names for their new born babies (Alter par. 1). They use different methods such as pulling ideas from book and websites, hiring professional baby-name consultant, and even check Social Security data (Alter par. 1). Maryanna Korwitt is a nameologist who spent years of studying ancient culture and past traditions as well as research with present-day people (About Maryanna). She started her own name business that helps people to choose right names not only for children but also for new companies and websites (Ferrell 235). She identified her target market as middle and upper class people. She writes books, makes television appearances, and provide consultations (Ferrell 235). Today, many books about baby naming are being published, and hundreds of websites are providing similar services, which all of these make her business more competitive (Alter par.3). Maryanna Korwitt took advantage of a recent trend to give babies unusual names (Ferrell 235). She studies names and how they could affect people’s lives. She believes that a child’s personality is determined by the name it is given, and therefore making the right choice is very important. While there has been an increased demand for help in choosing a child’s name, largely driven by the Hollywood penchant to choose odd names, in Korwitt’s case her business was not customer driven. She started her business...
Words: 745 - Pages: 3
...these four columns: Emp#, Lastname, Firstname, and Job_class. The table name should be EMPLOYEES. The Job_class column should be able to store character strings up to a maximum length of four, but the column values shouldn’t be padded if the value has less than four characters. The Emp# column contains a numeric ID and should allow a five-digit number. Use column sizes you consider suitable for the Firstname and Lastname columns. create table EMPLOYEES (Emp# number(5,0), Lastname varchar2(12), Firstname varchar2(12), Job_Class char(4)); 3. Add two columns to the EMPLOYEES table. One column, named EmpDate, contains the date of employment for each employee, and its default value should be the system date. The second column, named EndDate, contains employees’ date of termination. Alter Table EMPLOYEES Add (Empdate Date Default System, EndDate Date); 4. Modify the Job_class column of the EMPLOYEES table so that it allows storing a maximum width of two characters. Alter Table EMPLOYEES modify (Job_Class char(2)); 5. Delete the EndDate column from the EMPLOYEES table. Alter Table EMPLOYEES drop column EndDate; 6. Rename the EMPLOYEES table as JL_EMPS. Rename Employees To JL_EMPS; 7. Create a new table containing these four columns from the existing BOOKS table: ISBN, Cost, Retail, and Category. The name of the ISBN column should be ID, and the other col- umns should keep their original names....
Words: 424 - Pages: 2
...SQL> select bdate,address 2 from employee 3 where fname='John' and minit='B' and lname='Smith'; BDATE ADDRESS -------- ------------------------------ 65/01/09 731 Fondren, Houston, TX SQL> select fname,lname,address 2 from employee,department 3 where dname='Research' and 4 dnumber=dno; FNAME LNAME ADDRESS ------------------------------ ------------------------------ ------------------------------ John Smith 731 Fondren, Houston, TX Franklin Wong 638 Voss, Houton, TX Ramesh Narayan 975 Fire Oak, Humble, TX Joyco English 5631 Rice, Houston, TX SQL> select pnumber,dnum,lname,address,bdate 2 from project,department,employee 3 where dnum=dnumber and Mgr_ssn=ssn and plocation='Stafford'; PNUMBER DNUM LNAME ADDRESS BDATE ---------- ---------- ------------------------------ ------------------------------ -------- 10 4 Wallace 291 Berry, Bellaire, TX 41/06/20 30 4 Wallace 291 Berry, Bellaire, TX 41/06/20 SQL> select fname, employee.lname, address 2 from employee, department 3 where department.dname='research' and department...
Words: 2277 - Pages: 10
...History of Chinese Food 1. Cuisine and Culture: A History of Food and People (2011) states that from approximately 6000 B.C., Chinese started growing plants and raised animals to feed themselves. At around the same time, salt was harvested in Northern China. 2. Ancient story B. Culture of Chinese Food 1. According to Food and Culture: A Reader (2013), food can reflect the culture of a nation to some extent. 2. The Beauty of Neutralization of Han People's Culture in the Naming of Chinese Food (2006) clearly points out that the art of naming Chinese food is brilliant. a. Chinese Literature b. Best wishes c. Ingredient d. Examples of the names of Chinese food ① Visual aid 2: passing around the menu of a Chinese restaurant ② Showing names of Chinese food in Chinese and English, and pictures which the names refer to. 3. The personality...
Words: 424 - Pages: 2
...instance, : Sandra Cisneros, in her essay My name notes that a name can mean hope, many letters, sadness waiting (pg. 190) The naming in such cases has been as distinctly precise as none of the organisms named share the same names. In cases where they might share such names, there has always been a clear and precise way that conventionally applies in differentiating the two organisms. Under such situations, different methods are put into consideration. These methods of differentiation of names majorly depend upon the parental hierarchy of such organisms. Consequently, human beings also accord a lot of credit to the power of naming. However, the decision on which name to give to someone is not an easy task. People are named with regard to a number of factors. Some people may name their children after some renowned people. These people may be influential in the society or may have some adorable characteristics that the parents may want their children to adopt. Another factor that may define naming may be a remarkable or memorable occurrence. For instance: Lini S. Kadaba, in her essay, What‘s in a Name? Shows how Christopher Angelo Annas of South Philadelphia was named after his grandfather, Annas. The grandfather, initially named Papanastasiou but later changed the name to Annas on arrival to America. The grandchild later changed his name to Christopher Angelo Anastasiou, back to the original meaning. He claims that Annas, the name adopted by his grandfather sounded like part...
Words: 303 - Pages: 2
.... FORM 'F' GRATUITY NOMINATION To I. …..…………………………………… whose particulars are given in the statement below, [Name in full here] hereby nominate the person(s) mentioned below to receive the gratuity payable after my death as also the gratuity standing to my credit in the event of my death before that amount has become payable, or having become payable has not been paid and direct that the said amount of gratuity shall be paid in proportion indicated against the name(s) of the nominee(s). 2. I hereby certify that the person(s) mentioned is a/are member(s) of my family within the meaning of clause (h) of section (2) of the Payment of Gratuity Act, 1972. 3. I hereby declare that I have no family within the meaning of clause (h) of section (2) of the said Act. 4. a) My father/mother/parents is/are not dependent on me. b) My spouse’s father/mother/parents is/are not dependent on my spouse. 5. I have excluded my husband from my family by a notice dated ………………..to the Controlling Authority in terms of the proviso to clause (h) of section 2 of the said Act. 6. Nomination made herein invalidates my previous nomination. Nominee(s) |Name in full with full address |Relationship with the employee |Age of nominee |Proportion by which the gratuity| |of nominee(s) | | |will be ...
Words: 444 - Pages: 2
...In “Everyday Use” Alice Walker demonstrates the importance of one’s heritage, by showing how ignorant and unappreciative Dee is of the contributions made by her ancestors. Dee is characterized by what she says. On one occasion Mama addresses her by her birth name, Dee. In reply Dee says, “No Mama. Not “Dee,” Wangero Leewanika Kemanjo!” Mama asked why and she says Dee is dead and she couldn’t bear it any longer, being named after people who oppress her. Mama then highlights her ignorance of her family’s heritage by informing her on where her name originated. She tells Dee that she was named after her aunt, who was named after Grandma Dee, who inherited the name of her mother as well. A person who possesses real heritage and culture make use of it every day of their life on the other hand Dee exhibits being shameful and ignorant of her heritage. On another occasion Dee addresses her family about some quilts. She is determined to get the quilts, but has no idea or knowledge of how the family’s jewels are infused with the presence of the people who made and used them. It was made clear that mama understands that Maggie, not Dee, should have the quilts because Maggie will respect and appreciate the jewels by using them in the way they were intended to be used and not put on display like an exhibit at a museum. To Dee, heritage is the past, something to frame or hang on the wall, a mere artistic reminder of her family history. In Conclusion Dee is ashamed of her family’s heritage...
Words: 327 - Pages: 2
...the word. When a behaviour or skill seems to no longer require direct interaction, cognitive psychologists say it is automatized. Many behaviours can become automatized: typing, reading, writing to name just a few. To explore properties of automatized behaviours cognitive psychologists often put observers in a situation where an automatized response is in conflict with the desired behaviour. This allows researchers to test the behind-the-scenes properties of automatized behaviours by noting their influence on more easily measured behaviours. This demonstration explores a well-known example of this type of influence, the Stroop effect. Stroop (1935) noted that observers were slower to properly identify the colour of ink when the ink was used to produce colour names different from the ink. That is, observers were slower to identify red ink when it spelled the word blue. This is an interesting finding because observers are told to not pay any attention to the word names and simply report the colour of the ink. However, this seems to be a nearly impossible task, as the name of the word seems to interfere with the observer's ability to report the colour of the ink. A common explanation for the Stroop effect is that observers have automatized the process of reading. Thus, the colour names of the words are always processed very quickly, regardless of the colour of the ink. On the other hand, identifying colours is...
Words: 1169 - Pages: 5
...Snow White and the 10 planks of confidence “Hello my name is meera, im allison, and im fayha and we will be presenting the 10 planks of confidence through the story of snow white and the 7 dwarfs” Narrator: Once upon a time in the depths of the Planko Forest, a long lost princess makes her way to an isolated cottage in the middle of the forest. As she approaches the small house hoping to find help, she notices a bright light and hears a cry for help. She peers through the window and sees a strange image. Witch: “You dwarfs haven't been very loyal, so for that I take away any memories you have of yourselfs. See if you can find your way out of this.” [witch gestures hands in a spell like movement] [witch leaves] Narrator: Confused Snow White slowly makes her way into the cottage Snow White: “Hello? Is anyone there?” [walks around the class slowly, looking around] Narrator: She stumbles upon a group of small people Snow White: Hi! What’s your name? Dwarf 1: Umm I…. i dont know.. none of us do Snow White: You don’t know your name? well then I’ll name you Contenta, it stands for content. Narrator: Content: you pick a topic worth talking about. And you Research, research, research. Snow White: Do you want to help me name your other friends? Dwarf 1: Yah! [Snow White and dwarf 1 goes around naming 9 other dwarfs] Snow White: Your name is going to be Orgo for Organization. Narrator: Organization: You have a well planned outline that is easy for you and your...
Words: 658 - Pages: 3
...BUSINESS COMMUNICATION PRECONCEPTIONS ASSOCIATED WITH NAMES AND ITS ROLE IN INTERPERSONAL COMMUNICATION Submitted by: Gibin Venugopal(M130001MS) Roshni Yasmin Kallayi(M130006MS) Susan Joseph Kathaliyil(M130005MS) Vinay Mangire(M130010MS) PRECONCEPTIONS ASSOCIATED WITH NAMES AND ITS ROLE IN INTERPERSONAL COMMUNICATION INTRODUCTION Name of a person is what distinguishes him/her from the vast pool of people on this planet. Names are assigned to everything around us – people, places, things, chemical compounds, trees, technology, inventions and it goes on. Globalization has brought in a scenario at workplaces whereby people belonging to different countries, cultures, ethnic, religious and social backgrounds interact and work together in teams in global organisations. Even within countries, people mingle with others of different linguistic and cultural backgrounds. Whatever be the origin of a person’s name, it is a vital aspect of his life as the name is the primary identity that is used to set him apart from others in social interactions, especially daily conversation. In India, there is a significant percentage of people who name their children based on their religion or caste. Either the name or the surname reflects this aspect. When preconceptions are made about a person based on the sole aspect of his/her name, it creates a assumed or misinterpreted image of the name bearer. This greatly affects one’s mental attitude and communication with the other person...
Words: 1751 - Pages: 8
...Choices of the Name in Naming Game Abstract The naming games model on complex network have been studied in recent researched. Few research on the impact of the available choose of choice of names for the name game have been conducted. The purpose of this study is to find the relationship of the number of choices for the naming games affect the convergence time of the network. Introduction The purpose of this study is to find out the impact of the number of available choice of the name for the agent to negotiate to the hearer on the convergence time. Fully connected network and NW Small-world network will be used as the model of the software simulation for analyzing the effect of number of choice of names for the naming games The Model NW Small-World Network is used to evaluate the effect on the number of choice of the naming games. The naming game used in this study is modified from the traditional naming game. The algorithm of the revised naming game is as follows: 1. Construct a fully connected or NW Small-World network 2. Randomly select a connected node in the network as the Speaker. 3. Randomly select a neighbor from the Speaker as the Hearer. 4. The Speaker randomly selected a name from his memory and tells the name to the Hearer. 5. If the hearer already has the same name in his memory, the Speak and Hearer retain the uttered word as the correct name and cancel all other words form their memories. 6. Repeat Step 4 for multiple name negotiation until...
Words: 855 - Pages: 4
...The Kite Runner Final Essay AG Novel A literary work conveys a compelling story specific to its time and place. Additionally, a memorable one explores issues and themes (universal truths) that are important, and timeless, for all readers. Keep this in mind as you think about each essay prompt. A convincing essay will include direct citations from the novel, commentary and use of scholarly analysis. Visit the Gale Digital Library, accessible from the Venture website (password: venture) to search for support. Additionally, use MLA format for your essay and utilize correct citations. Questions taken, in part, from the Khaled Hosseini Foundation curriculum. 1. Writer and human rights activist Isabel Allende writes of The Kite Runner: “This is one of those unforgettable stories that stays with you for years. All the great themes of literature and of life are the fabric of this extraordinary novel: love, honor, guilt, fear, redemption.” Which of these major themes resonates the most with you? Choose one to focus on and show how author Khaled Hosseini communicates this universal truth through characters, plot development and use of symbols. 2. In great literature, no scene of violence exists for its own sake. In a wellorganized essay, explain how a violent scene in The Kite Runner contributes to the meaning of the complete work. Apply the concept of an extended metaphor to discuss the political and social portrait of Afghanistan. 3. Leo Tolstoy once wrote...
Words: 663 - Pages: 3
...Names Ever since I was a little boy, I always remembered wondering how and why things were named what they are; also why/ how the words were formed. On long road trips/ vacations I would look at street signs and store names in foreign places and wonder why things were named as they were. A group of people I thought who put a lot of meaning into what they named things were the Native American Indians. All of the places, people, even animals they named were very symbolic, and had an important meaning. I feel as if in today’s world we don’t put as much thought into the things we name. Even when parents name their kids, some just slap a name on their forehead (not literally.) They don’t think about how they want their child to be raised, or they want them to become as an adult. My good friend was given a made up name when he was born because his father was drunk. To me that’s just cruel. For one thing, it would be rather hard for him to complete an essay like this, but also knowing your name which is a big part of you, has no real meaning. My name, Owen, was passed down 3 generations before me. I asked my father “why has our name been passed down this long? Why did you name me it?” he told me that his great grandfather was born into slavery and explained to me how he was not given a name until he was released and shipped to Jamaica. There, he was adopted at a young age into a family. The family said my great grandfather was a fighter; taking a lot of abuse and seeing a lot...
Words: 1053 - Pages: 5
