Premium Essay

Being Me

In: Computers and Technology

Submitted By ced24co
Words 1353
Pages 6
SELECT e.firstName,c.CompanyName FROM Employees e JOIN Orders o ON e.employeeID=o.employeeID JOIN Customers c ON c.customerID=o.customerID ORDER BY e.firstName,c.CompanyName | |
Compelling, but we see that there's many repeated entries in the list. We'd like to count up how many sales are at the intersection of each distinct customer and salesperson. To do this we'll add in a COUNT function and GROUP BY clause. SELECT e.firstName,c.CompanyName, COUNT(o.orderID) FROM Employees e JOIN Orders o ON e.employeeID=o.employeeID JOIN Customers c ON c.customerID=o.customerID GROUP BY e.firstName,c.CompanyName ORDER BY e.firstName,c.CompanyName | |
Now the real fun begins as we transition this into a query that uses PIVOT. Because we're grouping by not one but two columns, this query is a good candidate for PIVOT. We'll start simple with a query that doesn't JOIN anything, but just references the Orders table. We'll choose to have Employee data put into columns since there are only 9 employees. Much more manageable. In this case the numbers 1 through 9 refer to the ID of employees:
SELECT * FROM Orders PIVOT (COUNT(employeeID) FOR employeeID IN ([1],[2],[3],[4],[5],[6],[7],[8],[9])) p

In the result set notice that the specific columns returned come from the result of the PIVOT clause and not directly from the Orders table! And that PIVOT clause brings up every column from the Orders table except for employeeID, which gets weeded out since it is used in the aggregate function COUNT. If it helps to visualize what's going on here, it's as if we had said “GROUP BY *” if such a thing existed. Another interesting thing about PIVOT is that there can be only one aggregate function and column referenced. In this case it's COUNT(employeeID).
To limit the columns returned to just what we need to show and aggregate, we'll have to use a...

Similar Documents

Premium Essay

Being Me

...University of Phoenix Material Literary Conventions and Devices Worksheet Names of Team Members:___Deborah Brown :Yolanda Powell; Joan Skeeter; Florence Ames; Amy Kennedy; Date: 12 Sept 2011 Each Learning Team should select two works of drama from the assigned readings for this assignment. All team members should contribute to filling out the tables and answering the questions for each play. Teams should be prepared to discuss their responses in class. |Literary Conventions and Devices Table | |Play #1 | |Title of the work |Significance of Title | |The Tragedy of Hamlet, |These plays were more over a small “history” of the main character and for this reason Shakespeare named all of | |Prince of Denmark |his great tragedies after his protagonist. | | | | |Identify |Describe |Explain Impact | |Major characters ...

Words: 3207 - Pages: 13

Premium Essay

Being Me

...We also moved early to open our network to outside innovators and broke new ground with our AT&T Foundry innovation centers, allowing us to deliver more apps and solutions to our customers faster. All of this has helped our company create new growth platforms. And more broadly, it has helped ignite a global wave of innovation that’s transforming how we manage our lives, connect with others and operate our businesses. It’s hard to overstate the impact of this revolution, or our company’s role in it. Simply put, we have created the framework for the fastest, largest technology transformation in our lifetime. But the fact is, as impressive as the past several years have been, the opportunities ahead are many times greater. This next wave is being powered by a combination of ultra-fast mobile communications with access to content located in the cloud. This means that just about everything in our world will be connected, seamless and smart. Our content will follow us no matter what device we’re using. Our homes and cars will be extensions of our smartphones 1 2013 Annual Report 2 2013 Annual Report and tablets. The highest levels of education will be accessible to millions more people wherever they are located, and advancements in healthcare will occur...

Words: 47286 - Pages: 190

Free Essay

Being Me

...Just For Today Just for today, I will live one day only and not try to solve the whole problem of life at once. Just for today, I will be unafraid of life and death, unafraid to enjoy the beautiful and to be happy. Just for today, I will adjust myself to what is, and not try to make everything over to suit me, If I cannot have what I like, I will try to like what I have. Just for today, I will be agreeable, cheerful, charitable, praise people for what they do and not criticize them for what they cannot do. And if I find a fault with another, I will forgive it and forget it. Just for today, I will have a plan. I may not follow it exactly, but I will have one. It will save me from worry, hurry and indecision. Just for today, I will look at life with fresh eyes and discover the wonder of it; I will know that as I give to the world, so the world will give to me. Just for today, I will show it if my feelings are hurt. Just for today, I will not try to improve or regulate anybody except myself. Just for today, I will find a little time to relax and to realize what life is and can be, time to think about God, and get a better perspective on myself. Thank you, my God, for another today. Yesterday is already a dream, and tomorrow is only a vision, but today well lived make every yesterday a dream of happiness and every tomorrow a vision of hope. From a Friend to a...

Words: 281 - Pages: 2

Premium Essay

David Benatar Better Never to Have Been Review

...earlier stage should be aborted. It results that the existence of one person should counted as overpopulation, and it is good for human to extinct. In the introduction, Benatar first claims that his argument can be applied to all sentient beings, but his focus will be on humans. In the part subtitled “Who is so lucky”, Freud's claim that there is no good or best for the non-existent people elicits the 'non-identity' problem, which will later be solved. By speaking about the 'never-existent' which refers to nothing, Benatar is using this expression as a convenient term to mean those possible but non-actual beings. In Chapter 2, Benatar firstly claims that the expression 'a life worth living' should be specified as either 'a life worth starting' or 'a life worth continuing'. Then he tries to explain why coming into existence is always a harm by the asymmetry of pleasure and pain: (1) the presence of pain is bad, (2) the presence of pleasure is good, (3) the absence of pain is good, (4) the absence of pleasure is not bad unless it implies a deprivation. The first two points are evident, but (3) and (4) are controversial. The 'non-identity' problem can be raised against (3), since (3) can be interpreted as the absence of pain is good for the nonexistent being. Benatar replies that (3) claims that “this absence is good when judged in terms of the interests of the person who would otherwise have existed” (2006: 31). However, this reply is still problematic since it implies a...

Words: 844 - Pages: 4

Premium Essay

“the Ontological Argument Does Not Succeed in Going Beyond Defining God” to What Extent Is This True?

...philosophers such as Alvin Plantinga and Descartes, defines God as “a being that which nothing greater can be conceived”. In my opinion the argument does not only fail to go beyond this definition, but we cannot be sure than it defines God correctly either. Firstly we cannot argue that the argument goes beyond the definition of God because as Kant points out the argument has a major flaw, the ontological argument is based on an assumption that to exist is a property of perfection. He uses the analogy of money saying that 100___ that existed in reality were no different in value to 100___ that existed hypothetically as both, in theory were worth the same and therefore equal. Bertrand Russell makes a similar point, he claims that the ontological argument uses the word ‘exists’ incorrectly and that existence is not a property of things, but of the idea of those things. Russell uses the example of dragons, saying that if someone says a dragon does not exist what they mean is of all the things that exist the word dragon refers to none of them, however this fact is not part of the definition itself and changes nothing about the description of the features of a dragon, therefore existence is an extension of an intention and not a definition. Alvin Plantinga attempts to redeem the ontological argument with his possible world’s theory, planting argues that if it is coherent to believe that in a possible world a maximally great being could exist then in order for him to have maximal......

Words: 429 - Pages: 2

Premium Essay

Hello

...God—proofs that were dependent on reason and observation, not the revealed word of God. 1. Aquinas recognized that for motion to take place, there had to be something that interacts with it to cause it to move. This, in turn must be an infinite being outside of creation and hence is God. 2. Every effect must have a cause, if you eliminate the cause you eliminate the effect. It only posits that a God exists who is the cause of all things and who is the effect of nothing. 3. Aquinas argued that from observation, the things around him had the possibility of being (or existing) or not being. Yet, if that first being exists, he must necessarily not have the possibility of not being.  In other words, as non-existence cannot bring about existence, the first being necessarily has to have always existed.  And this entity that necessarily exists and cannot not-exist, is God. 4. Note that this is not the suggestion that we get the idea of goodness or hotness from God, but simply that there must always be something that is more good or more hot than that which we are viewing and since there is a gradation, there must always be a top to the gradation that can never be surpassed.  Such a top or asymptote, by definition, requires an infinite being, hence it must be God. 5. Fifthly, Aquinas points out that there are entities in creation that have no consciousness at all, yet still act in a regular fashion and in such a way that it is beneficial to their continued existence.  Trees, for......

Words: 308 - Pages: 2

Premium Essay

Aristotle

...horses did not exist, there would be no such thing as the form horse. Is this correct? * I believe Aristotle was incorrect by saying there could be no form of a horse if there were no actual physical particular horse with which to base the form on. I justify this based on my understanding of the notion of a form, namely – the form of the object is purely human convention that assigns words to concepts and then judges wheter particular objects conform to our definition. We could conceive if something that we would call a horse even if there was never an object that we could find which conformed to our conception. 4. Can there be essence without existence? * Everything has two principles that explain its being, essence and existence. In all beings except for God, these principles are both required in order for the actually existing individual thing to be. Each is distinct from the other, yet this distinction is a real, not merely logical. 5. What are the two kinds of substance * For Aristotle two kinds of substance is from and essence. The kind of essence or form that Aristotle counts as primary substance is one that is not in any way universal; a form that is as individual as the compound whose form it is. The “individual forms” solution is not to be found in Aristotle, and is unavailable to him. On their view, the primary substance of the Metaphysics is species form - something that is common to different members of the same species, but is still, in......

Words: 273 - Pages: 2

Free Essay

What Am I Doing?

...expected and required. * These policies should include conflict of interest and code of ethics section. * Procedures should be updated every year * It is important that employees are taught and trained in the policies so that they learned of their existence and they get a sense of what is expected of them. * It is also important to exercise segregation of duties in the workplace. This means require different parties to perform key parts of the transaction. Specifically, separate the authorization, custody, record keeping and reconciliation duties. In the case, not only is Jessica in charge of the custody and record keeping duty, but there also seems that there isn’t any supervising bank reconciliation activity being performed. There are different controls that this entity could have used to avoid segregation of duties problems experienced that led to the burglary of funds by Jessica. Some of these are: * Implement a bank lockbox system that receives the entity payments. These system would have avoided Jessica or any employee to have to deal with cash by just getting bank notifications of the daily deposits for recording. * If a lockbox system is unavailable/undesirable, two entity’s employees should receive payments, list the payments and generate deposits. * This control could be circumvented by collusion of employees. * Additionally, periodic reconciliations of cash receipts for entities books should be......

Words: 280 - Pages: 2

Free Essay

Transcendental Properties of Being

...TRANSCENDENTAL PROPERTIES OF BEING By: MBAKWE NICHOLAS CHUKWUNWEIKE Introduction Metaphysics is not just a science in Aristotle’s conception of it, but one that distinguishes itself from all the particular sciences by firstly raising the question of the first and most universal causes and secondly by taking as its subject of consideration ‘being’ simply as ‘being’ in its most universal and in its most concrete sense as present in experience. Implicitly, being must be taken as analogous from the very beginning of the investigation, not in the sense that it would diffuse the unity of this science into a mere difference of differences, but in the sense that it would raise this science to a higher kind of unity according to an order of different degrees of being as they relate to a primary analogate as the one to which all relate more or less distantly. To delve more deeply into this analogous subject of consideration one must further distinguish transcendental properties that follow being in its analogous and transcendental sense. In the end, when the question of a first, universal cause of being as being, or of a summit of being that would be totally transcendent, is finally raised, all of this a priori conception of being as analogous according to different degrees with its corresponding degrees of oneness, activity, truth and goodness must be brought into play in relation to things as they come under sense experience as moved, caused, contingent and exhibiting different......

Words: 2742 - Pages: 11

Free Essay

What Is Philosophy?

...having a hidden meaning, and as I have quickly learned, philosophy is a very mystifying subject and is open to a wide variety of interpretation. Due to this obscurity, each person will have a different view on philosophy and will likely have changing opinions and views as they continue on their path. Heidegger describes this path as one of responding to life. More specifically, “responding to the voice of Logos which he defines as the Being of all beings, One, One which is all, Life.” As previously stated, this is a very cryptic definition that takes much deeper thought than simply reading off the page.   Despite being cryptic, this vague definition gives a strong guideline to the basic idea of philosophy while still giving the reader an opportunity to interpret the definition in their own way. This definition shines light on both the basic idea of philosophy while also showing that everyone will interpret philosophy in their own way. By saying that philosophy is the One which is all, it shows that each individual person makes up a greater being which is Life. Each individual person provides their own interpretation based on their own lifestyle and past. Therefore, philosophy is the sum of all lives that can only be defined with the sum of everybody’s views and opinions. With this is mind, philosophy will be ever changing as people grow older and more people are brought into the world. What is most important about this definition is that it is timeless. This definition......

Words: 327 - Pages: 2

Free Essay

Attributes of Being

...Transcendental Attributes of Being A research paper submitted to [Professor Name] In Partial Fulfillment of the requirements For The course [Course Name] [Seminary Name] By [Student Name] Place Date Introduction While Plato had also covered the notions surrounding the properties of being, Aristotle was the first to bring the term transcendental to the context of the attributes of being. Plato offered valuable insight regarding the four transcendental attributes of being. [1] Aristotle shaped the transcendentals in a specific manner and refined his own perspective. Later philosophers also expanded the discussion surrounding the transcendental attributes of being. These transcendentals become significant in the context of theology because they possess a link with Christian theology and unfold in the form of what man desires. For explicating the four transcendental attributes of being, it becomes significant to first explore the definition of an attribute. An attribute falls under the category of that aspect which does not exist in the form of the embodiment but originates from the same. As regards ‘being’, it can only give rise to what is also being and thus, a ‘being’ cannot spawn attributes or properties while discussing these terminologies in a firm manner. Nevertheless, while approaching the subject in a broader manner, an attribute can be defined for a specific perspective on being as long as it applies to each instance of being and overall entities that......

Words: 1802 - Pages: 8

Premium Essay

The Importance Of Being Hispanic To Me

...Being Hispanic to me, means being apart of a big family. All my life I have lived with my extended cousins, and I thought it was normal. When I started going to school is when I realized that other people, other races and nationalities, did not live the same way I did. However, it did not make me feel outcasted or left out, it made me different and special. These people did not get to experience what I was experiencing at home. Yes, I had basically no privacy, but I had fantastic loving people around me around the clock. Being Hispanic means loud gatherings, great food, music, dancing, and having a good time. Holidays are never quiet in a Hispanic household and it certainly was not in my household. Not only did we have turkey on Thanksgiving...

Words: 284 - Pages: 2

Free Essay

Martin Heidegger Philosophy

...religious thinking. It is important to point out that Heidegger’s philosophy is extremely complex and he never completed his second half of his endeavour, hence a brief explication will not do his thinking justice but a complete explanation is outside the scope of this essay. Therefore, in this essay I will primarily focus on Heidegger’s five key concepts; i) the transience of reality, ii) human existence, iii) Being-in-the world, iv) objects and things and v) metaphysics and Being. The transience of reality This ‘transience of reality’ according to Heidegger reflects the idea that everything is “temporary and changeable” (RST3708 Study Guide 2008:59). Whereas modern subjectivism refers to the “attitude in terms of which the whole of reality is traced back to the subject” (RST3708 Study Guide 2008:58), Heidegger contends that reality exists before the subject can be identified, as written in the Study Guide (RST3708 Study Guide 2008:58), “reality as a mystery has already happened”. Heidegger claims that only once a comprehensive examination is made into Being, will there be space for a new revelation, a “postsubjectivist experience – of reality”...

Words: 1980 - Pages: 8

Free Essay

What Being a Snco Means to Me

...What Being a SNCO Means to Me When I was a young airman coming through basic training whenever I saw a Tech Sergeant I knew it meant that they were at the top of their game. That they had earned the respect of everyone around them as proficient and capable leaders. Oh but then I was exposed to another entity. One that the Tech Sergeant looked up too and strived to become. It was the rank of SNCO, the top of the enlisted force structure. But what does that mean? Depending on who you ask, if they have been mentored and what experiences they have during their careers, you may get several different answers to this questions. Here’s what it means to me. I heard someone say that a wise man learns from his mistakes but a wiser many learns from others mistakes. As a SNCO I believe that it is now my turn to focus on those that are coming behind me. Explain to that young Airman why it is important to work on their education and what their role in the big picture is. Sit that Jr. NCO down and ensure that air taking care of that airman and ensure they are doing great things and recognizing them for it with award packages and other incentives. That they themselves have to be the example because airman hear what they see. So in order for me to expect them to be the example I have to set the tone. In order for me to do that, I look towards my seasoned SNOC’s to mentor me so that I can ensure that I am giving my subordanents a superior product. It is now time for me to......

Words: 312 - Pages: 2

Free Essay

Introducion Al Eviews

...Introducción al E-views Importante: Este manual está todavía en proceso (de hecho sos el primero en utilizarlo) así que se agradecerá todos los errores u horrores que encuentres, así como sugerencias para mejorarlo. Correcciones a: ndepetris@utdt.edu o ivanca@arnet.com.ar . El producto E-views provee herramientas de regresión y predicción bajo Windows. Con E-views usted puede revelar una relación estadística desde sus datos y luego utilizar esta relación para predecir valores futuros de los mismos. Dentro de las áreas en donde E-views puede ser útil están: Predicción de ventas Análisis y predicción de costos. Análisis Financiero. Predicción macroeconómica. Simulación. Análisis científico de los datos y evaluación. E-views es una nueva versión del conjunto de herramientas para manipular series de tiempo originalmente desarrolladas en el software Time Series Processor para grandes computadoras. El predecesor inmediato de E-views fue el MicroTSP, lanzado por primera vez en 1981. Aunque Eviews fue desarrollado por economistas y la mayoría de sus usos están en la economía, no hay nada que haga limitar su utilidad a las series de tiempo económicas. Inclusive considerables proyectos de corte transversal pueden llevarse a cabo en E-views. El objeto básico dentro de E-views es la serie de tiempo. Cada serie posee un nombre, y usted puede realizar cualquier tipo de operación sobre todas las observaciones simplemente mencionando el nombre de la serie. E-views provee......

Words: 8183 - Pages: 33