# Micro Computers Quiz 1

Submitted By mscott656
Words 318
Pages 2
Part 1 1. What are the Sales Amount by Channel?
SELECT DimChannel.ChannelName, Sum(FactSales.SalesAmount) AS SumOfSalesAmount
FROM DimChannel INNER JOIN FactSales ON DimChannel.ChannelKey = FactSales.channelKey
GROUP BY DimChannel.ChannelName; a. By Channel by Year
SELECT DimChannel.ChannelName, DimDate.FiscalYear, Sum(FactSales.SalesAmount) AS SumOfSalesAmount
FROM DimDate INNER JOIN (DimChannel INNER JOIN FactSales ON DimChannel.ChannelKey = FactSales.channelKey) ON DimDate.Datekey = FactSales.DateKey
GROUP BY DimChannel.ChannelName, DimDate.FiscalYear; b. Show the results with the best year at the top
SELECT DimChannel.ChannelName, DimDate.FiscalYear, Sum(FactSales.SalesAmount) AS SumOfSalesAmount
FROM DimDate INNER JOIN (DimChannel INNER JOIN FactSales ON DimChannel.ChannelKey = FactSales.channelKey) ON DimDate.Datekey = FactSales.DateKey
GROUP BY DimChannel.ChannelName, DimDate.FiscalYear
ORDER BY Sum(FactSales.SalesAmount) DESC; 2. What are the different types of Promotions?
SELECT DimPromotion.PromotionName
FROM DimPromotion; c. What are the start and end dates for each promotion. Put the oldest start dates first
SELECT DimPromotion.PromotionName, DimPromotion.StartDate, DimPromotion.EndDate
FROM DimPromotion
ORDER BY DimPromotion.StartDate; 3. What are the quantity and the amounts of items returned grouped by Channel then by Manufacturer?
SELECT DimChannel.ChannelName, DimProduct.Manufacturer, Sum(FactSales.ReturnQuantity) AS SumOfReturnQuantity, Sum(FactSales.ReturnAmount) AS SumOfReturnAmount
FROM DimProduct INNER JOIN (DimChannel INNER JOIN FactSales ON DimChannel.ChannelKey = FactSales.channelKey) ON DimProduct.ProductKey = FactSales.ProductKey
GROUP BY DimChannel.ChannelName, DimProduct.Manufacturer; 4. What is the average Weight of products sold grouped by Product Subcategory?
SELECT...

### Similar Documents

#### Economic

...OBJECTIVES VISION In pursuit of perfection, the University of Baguio is committed to provide balanced quality education by nurturing academic excellence, relevant social skills and ethical values in a fun-learning environment. MISSION The University of Baguio educates individuals to be empowered professionals in a global community. OBJECTIVES The University of Baguio aims to produce a graduate who: exemplifies a higher standard of learning; manifests the mastery of relevant skills; upholds a conduct that is rightful and just; undertakes scientific and significant researches; advocates sustainable programs for the community and the environment; and leads and demonstrates exemplary performance in the field of specialization. IV. V. VI. 1. 2. 3. 4. 5. 6. VII. SCHOOL MISSION AND OBJECTIVES SCHOOL OF DENTISTRY MISSION The University of Baguio educates individuals to be empowered professionals in a global community. The School of Dentistry is committed in providing excellent dental education to produce competitive and socially responsible dentists. OBJECTIVE The UB School of Dentistry provides a conducive and responsive learning environment which aims to produce an epitome of a...

Words: 1484 - Pages: 6

#### Essay

...available. Topics include contemporary issues such as inflation, unemployment, economic growth, international dependencies, and how public policy deals with them. | Instructor Contact Information: | Campus Location: | Prestonsburg | Building & Room: | Pike 215D | Office Hours: | N/A | Office Phone Number: | 1-888-641-4132 | Alternate Number: | 886-3863, Ext. 64781 | Best Times to Call: | The best place to communicate with me is in the message area of the blackboard course shell. | KCTCS Email: | Daniel.bell@kctcs.edu | Special Instructions: | N/A | Supervisor Contact Information: | Name: | Kelli Hall | Campus Location: | Pikeville | Building & Room: | N 102 | Office Phone Number: | 606-218-1275 or Ext 81275 | KCTCS Email: | Kelli.Hall@kctcs.edu | Text and Supplies: Macroeconomics, McConnell & Brue, Flynn 19th Edition – Copyright 2012 by McGraw-Hill-Irwin. | | Approved Course Competencies General Education: (KCTCS General Education Competency Statements and General Education Requirements) | I. Communicate Effectively | 1. Read and listen with comprehension. 2. Speak and write clearly using Standard English. 3. Interact cooperatively with others using both verbal and non-verbal means....

Words: 2128 - Pages: 9

Free Essay

#### Paper

...Department Head: Kim Breivogel 919-866-5203 or kbbreivogel@waketech.edu Course Delivery/Location: Delivery of this online course will take place through Blackboard. Students must log in and check Blackboard regularly for class policies, resources, assignments, and essential communications from your instructor. Blackboard can be accessed at https://dist-ed.waketech.edu/webapps/ login/. Wake Tech email (mywaketech.edu) will also be used and must be checked regularly. **This syllabus is subject to change. IMPORTANT DATES : All online students are expected to enter this class on the first day of class : Wednesday, September 14, 2011. Week 1 Assignments must be completed by midnight on Tuesday, September 20, 2011. 10% date : Wednesday, September 21, 2011 If a student fails to complete the assignments for Week 1 or does not communicate with the instructor by September 21, 2011, he or she will be dropped from the course by the instructor. Withdrawing with a W grade : Tuesday, November 8, 2011 The last day to drop this course with a non-punitive grade of W is Tuesday, November 8, 2011. If you wish to drop this course, you may do so yourself, or I can submit an online withdrawal form for you. Course Description: This course introduces the scientific study of human society, culture and social interactions. Topics include...

Words: 5763 - Pages: 24

Free Essay

#### Jkgkjk

... |Office Phone: (305) 348-3466 | |12:30-1:30 p.m. and 3:30-4:00 p.m. | | |Office: DM 281A |E-mail: Use Moodle course mail ONLY! | | |FIU e-mail: shpurikm@fiu.edu | |Teaching Assistant (TA): Jesse Slappey |TA Email: Use Moodle course mail ONLY! | |PSY 2012 Training and Development Center: Room DM 284, phone: 305-348-6892 | |Office hours: Mondays 10 a.m. - 2 p.m. (TA Ben) | |Tuesdays 3.30 - 6.30 p.m. (TA Ben) | |Wednesdays 10.30 a.m. - 1.30 p.m. (TA Brittany) | |Thursdays 8.30 a.m. - 3.30 p.m. (TA Jesse) | |Fridays 10 a.m. - 1 p.m. (TA Ben)...

Words: 4292 - Pages: 18

#### Economics

...Intermediate Macroeconomics Semester 1, 2015 Unit of Study Outline Unit Coordinator: Dr. Stella Huangfu Location: Room 339, Merewether Building Email address: stella.huangfu@sydney.edu.au Phone: +61-2-9036 9311 Consultation Hours: Thursdays 2-4 pm or other times by appointment. Tutors: Email address: Consultation Hours: Class times: Thursday 11am-1pm  Venue: Bosch Lecture Theatre 2 This Unit of Study Outline MUST be read in conjunction with the Faculty of Arts and Social Sciences Student Administration Manual (http://sydney.edu.au/arts/current_students/student_admin_manual.shtml) and all applicable University policies. In determining applications and appeals, it will be assumed that every student has taken the time to familiarise themselves with these key policies and procedures. [ECOS2002 Intermediate Macroeconomics] UNIT DESCRIPTION This unit of study develops models of the goods, money and labour markets, examines issues in macroeconomic policy. Macroeconomic relationships, covering consumption, investment, money and employment, are explored in detail. Macro-dynamic relationships, especially those linking inflation and unemployment, are also considered. Exchange rates and open economy macroeconomics are also addressed. In the last part of the unit, topics include the determinants and theories of economic growth, productivity and technology, the dynamics of the business cycle, counter-cyclical policy and the relationship between micro and macro policy in......

Words: 3541 - Pages: 15

Free Essay

#### Technology

...VOCATIONAL HIGHER SECONDARY TEACHER’S SOURCE BOOK COMPUTER SCIENCE FIRST YEAR Government of Kerala Department of Education SCERT - 2005-06 STATE COUNCIL OF EDUCATIONAL RESEARCH AND TRAINING Vidyabhavan, Poojappura, Thiruvananthapuram-12 Prepared by: State Council of Educational Research & Training (SCERT) Vidyabhavan, Poojappura, Thiruvananthapuram -12 Kerala E-mail:scertkerala@asianetindia.com Type setting by: SCERT Computer Lab. © Government of Kerala Education Department 2005 P REFACE Dear Teachers, Computer Science is concerned with the gathering, manipulation, classification, storage and retrival of knowledge. Understanding Computer Science, is necessary because of its power and influence in modern society. Learning of Computer Science should be activity based, process oriented, student-centred, environmental based and life oriented. The approach to learning is based on five domains of science: Knowledge domain, process domain, application and connection domain, domain of attitudes and values and creativity domain. But we know that most of the present vocational higher secondary teachers are not familiar with this paradigm. Hence for the first time we are introducing sourcebooks for all the subjects in the vocational higher secondary curriculum. This source book for computer science aims to provide guidelines to the teachers of our state to change their pedagogy from the conventional content-based approach to the process...

Words: 27034 - Pages: 109

Free Essay

#### Abcd

...2015-17 Semester II Course Outline 1 Shanti Business School, Ahmedabad PGDM 2015-17: Program Structure Semester-1 Semester-2 Semester-3 Semester-4 Course credit Course credit Course credit Language Skills @ Written Analysis & Communication @ Soft skills II @ Employability Skills @ IT & MIS 2 Soft skills I @ Computing skills 2 Social Media Marketing @ 2 Legal Aspects of Business 2 Business Strategy 3 Management Control Systems 3 Micro Economics 3 Macro Economics 3 Business Environment 3 Business Ethics & Corporate Governance 2 Quantitative Methods-1 3 Business Research Methods 3 Quantitative Methods-2 3 Core Elective-1 3 Core Elective1 3 Core Elective-2 3 Core Elective2 3 Elective-1 3 Elective-1 3 Elective-2 3 Elective-2 3 Grand Project-1 3 Grand Project-2 3 Principles of Management Basic Building Blocks Autumn Break Executive Skills Organisational Behavior Human Resources Management 3 Marketing Management 1 3 Marketing Management -2 3 Understanding Financial Statements 3 Financial Mgt 3 Operation Management Management Domain 3 3 Basics of Business Planning 2 Electives Credits Autumn Break credit SUMMER INTERNSHIP Course S 1 22 S......

Words: 7010 - Pages: 29

Free Essay

#### Innovation and Erp Systems

...Scheme and Syllabus of B.E. (Computer Science and Engineering) 3 rd th TO 8 Semester 2014-2015 University Institute of Engineering and Technology, Panjab University, Chandigarh DEPARTMENT: COMPUTER SCIENCE AND ENGINEERING VISION: To be recognized as an international leader in Computer Science and Engineering education and research to benefit society globally. MISSION: · · · · To move forward as frontiers of human knowledge to enrich the citizen, the nation, and the world. To excel in research and innovation that discovers new knowledge and enables new technologies and systems. To develop technocrats, entrepreneurs, and business leaders of future who will strive to improve the quality of human life. To create world class computing infrastructure for the enhancement of technical knowledge in field of Computer Science and Engineering. PROGRAMME: B.E. CSE (UG PROGRAMME) PROGRAMME EDUCATIONAL OBJECTIVES: I. Graduates will work as software professional in industry of repute. II. Graduates will pursue higher studies and research in engineering and management disciplines. III. Graduates will work as entrepreneurs by establishing startups to take up projects for societal and environmental cause. PROGRAMME OUTCOMES: A. Ability to effectively apply knowledge of computing, applied sciences and mathematics to computer science & engineering problems. B. Identify, formulate, research literature, and analyze complex computer science & engineering problems reaching substantiated......

Words: 23989 - Pages: 96

Free Essay

#### Ink Out of Tea Bags

...CHAPTER 2 This chapter includes the review of related literature, review of related studies and review of other related Computer Assisted Instruction (CAI) which helped the researchers in designing and developing their own CAI that was used in this research. REVIEW OF RELATED LITERATURE The review includes discussion of technical terms like Computer-Assisted Instruction (CAI), multimedia, and review of software packages in mathematics, studies on development, evaluation and validation of CAI materials. Instruction and Learning Instruction is the arrangement of information and environment to facilitate learning. By environment, we mean not only where instruction takes place but also the methods, media and equipment needed to convey information and guide the learner’s study. Information and environment can be arranged on a continuum from very formal to very informal. The relationship between information and environment can change depending on the instructional goal. The arrangement of information and the environment is normally the responsibility of the instructor and the designers of media. The choice of the strategy of instruction determines the environment (the methods, media, equipment and facilities) and how the information is assembled and used. The method can range from teacher control to learner control. Learning is the development of new knowledge, skills, or attitudes when the individual interacts with information and environment. Learning takes......

Words: 15415 - Pages: 62

Free Essay

#### B.Tech (Eee) Syllabus for 2012-13 Admitted

...GITAM UNIVERSTIY (Declared as Deemed to be University U/S 3 of UGC Act, 1956) [pic] REGULATIONS & SYLLABUS Of B.Tech. (Electrical & Electronics & Engineering) (W.e.f 2012-13 admitted batch) Gandhi Nagar Campus, Rushikonda VISAKHAPATNAM – 530 045 Website: www.gitam.edu REGULATIONS (W.e.f. 2012-013 admitted batch) 1. ADMISSIONS 1. Admissions into B.Tech (Electrical & Electronics Engineering) programme of GITAM University are governed by GITAM University admission regulations. 2. ELIGIBILTY CRITERIA 1. A pass in 10+2 or equivalent examination approved by GITAM University with Physics, Chemistry and Mathematics. 2. Admissions into B.Tech will be based on an All India Entrance Test (GAT) conducted by GITAM University and the rule of reservation, wherever applicable. 3. STRUCTURE OF THE B.Tech. PROGRAMME 3.1 The Programme of instruction consists of: i) A general core programme comprising Basic Sciences, Basic Engineering, Humanities & Social Sciences and Mathematics. ii) An engineering core programme imparting to the student the fundamentals of engineering in the branch concerned. iii) An elective programme enabling the students to take up a group of departmental / interdepartmental courses of interest to him/her. In addition, a student has to i)...

Words: 3379 - Pages: 14

#### Celluar

...Western International University IT-330-6940-Emerging Technologies Instructor Parikh, Raj By Shanon Ellis June 18, 2012 In recent years, with the demand for communication and information, the number of people using mobile phones has developed rapidly. People are more and more dependable on these small devices. It is clear that cell phone have benefited to every user in many sides of their lives. First of all, mobile phones, as a communication tool, connect people around the world. Many years ago, it was very difficult to contact with your friends, your partners immediately. Business man had to use their telephone in their office. When they went out, it was impossible to keep in touch with their business partners. That has led to the necessary to have mobile phone. Therefore, the mobility of owing a mobile phone has encouraged using this device. The number of people having mobile phone made a boom in last ten years. Another benefit of mobile phones is to help people in entertainment and supporting material for learning. These mobile phones have a lot of functions. Furthermore, smart phones have its own operating system such as Symbian, window mobile, android, or IOS. Users can set up applications to help us study such as dictionary. It is also an assistant for business people. These people schedule their works on this smart phones, it will remind them for that works. In some cases, with the GPS function, phone will guide you if you are in the new...

Words: 2223 - Pages: 9

Free Essay

#### Communications Training Module

...Personal Safety: What are they thinking? Training Session By: Edward J. Hamilton Business Communication PRCM325J Ohio University 2010 Table of Contents Overview 3 Behavioral Objectives 4 Outline of Training Session 5 Literature Review: What are they thinking? 7 Bibliography- Literature Review 10 Attachment 1: Study Abroad Handbook: Risk Factors and Strategies to Reduce Risk 12 Attachment 2: Proxemic circle 15 Attachment 3: Multi-Cultural meanings of Paralanguage Gestures 16 Personal Safety: What are they thinking? Overview Criminals are bolder and have less regard for their victims than ever before. Places that once seemed safe are no longer immune from danger. The death spiral of the economy plays a major factor in the increase of crime. There are two parties involved in the commission of crimes, to both persons and property; those two parties are the potential victim and perpetrator. Within each of those parties at the time of a commission of a crime, they possess an innate sense of non-verbal and verbal communication that engage, takes over and governs each party’s behavior throughout the event. For each respective party in a personal contact situation, that sense comprises of a series of cues which could take the form of voice intonation, body language, strength in numbers, and the surprise of direct violence. In some cases, the exchange can be analogous to a chess game in hyper drive. In other cases, the exchange may not be......

Words: 7335 - Pages: 30

#### Gujarat Technological University Syllabus for New Mba Program Effective from Academic Year 2011-12 Mba I Semester I

...Gujarat Technological University Syllabus for New MBA Program effective from Academic Year 2011-12 MBA I Semester I Accounting for Managers (AFM) 1. Course Objective: The objective of the course is to acquaint the students with the language of Accounting and to develop in them the ability to evaluate and use accounting data as an aid to decision making. The main purpose is to assist the students in developing skills in problem solving and decision making in the financial area. Emphasis is laid on analysis and utilization of financial and accounting data for planning and control. 2. Course Duration: The course duration is of 36 sessions of 75 minutes each i.e. 45 hours. 3. Course Contents: Module No: Module Content No. of Sessions 70 Marks (External Evaluation) 17 I II Fundamentals of Accounting Basic understanding of accounting, Accounting Concepts, Conceptual framework of financial statements, Accounting Policies, Journal Entries and preparation of accounts - Trial Balance to Balance sheet and profit and loss Account, Recognition of Income and Expenses, Provisions, Contingent Liabilities Accounting Standards and Applicability: Disclosure of Accounting Policies (AS-1), Valuation of Inventories (AS-2), Depreciation Accounting (AS-6), Income Recognition & Accrual Income (AS-9), Accounting of Fixed Assets (AS-10), Accounting for Intangible Assets (AS-26), Accounting for Investments (AS-13), 7 7 17 III IV V Preparing and Understanding Financial......

Words: 5698 - Pages: 23

#### Test

...Post Graduate Program in Management (PGPM) Faculty Name | Prof. S.K. Shanthi | Year/Term | 2014-15/Term-1 | Course Name | Micro-economics | No. of Credits | 3 | No of Contact Hours | 20 | Session Duration | 90 Min. | About the Instructor: Prof. S.K. Shanthi shanthi.sk@greatlakes.edu.in Course Objectives and Key Take Aways This course is designed to introduce students to basic microeconomic theory at a relatively rapid pace. The focus will be on fundamental economic principles that can be used by managers to think about business problems, including those inside the firm (relating to the problem of administering the firm’s resources in the most cost-effective way) and those outside the firm (relating to broader market and government forces that can affect the behavior of firms). In particular, it addresses how businesses make choices concerning the use of scarce resources, how prices and incomes are determined in competitive markets, and how market power affects the prices and quantities of goods available to society. We will also examine the impact of government intervention in the economy. At the end of the course the student should be able to: 1. Explain price and output changes in markets using supply and demand. 2. Analyse the usefulness of the concept of elasticity of demand in pricing, market segmentation decisions. 3. Find the profit maximizing level of various firm activities using marginal analysis. 4.......

Words: 2234 - Pages: 9