Premium Essay

Lesson 5

In:

Submitted By koach09
Words 327
Pages 2
2. How do you form a simple condition?
SELECT STUDENT_ID
FROM STUDENT
WHERE STUDENT_NUMB = ‘000843’;
3. How do you form a compound condition?
By connecting two or more simple conditions with the AND, OR, and NOT operators
9. How do you sort data?
You can sort data by using the ORDER BY operator.
12. What are the SQL aggregate functions?
The SQL aggregate function are functions used to calculate sums, averages, counts, maximum values, and minimum values.
14. What is a subquery?
When a query is inside of another query the inner query is the subquery.
15. How do you group data in an SQL query?
You can group SQL query data by using the GROUP BY clause on a particular object.

16. When grouping data in a query, how do you restrict the output to only those groups satisfying some condition?

By using the HAVING clause a query can be written to display the groups that are included

Also complete the following Exercises using the Premier Products database on page 132:
3. List the names of customers with credit limits of $10,000 or more.

5. List the number and name of each customer represented by sales rep 35 or sales rep 65.

8 List the part number, part description, and on-hand value (units on hand * unit price) of each part in item class SG.(On-hand value is really units on hand * cost, but there is no COST col- umn in the PART table.) Assign the name ON_HAND_VALUE to the computed column.

9. List the part number, part description, and on-hand value for each part whose on-hand value is at least $7,500. Assign the name ON_HAND_VALUE to the computed column. 11. Find the number and name of each customer whose name begins with the letter “B.” 15. Find the total of the balances for all customers represented by sales rep 65 with balances that are less than their credit

Similar Documents

Premium Essay

Design an Activity of Everyday Living Suitable for a Child/Children of a Specific Age; Between the Ages of 2½ and 5 Years of Age. Write It Up as a Full Lesson Plan Following the Attached Model. Present the Lesson to the

...DAY LIVING – Pairing and Folding of Identical Socks. Materials: A small Basket containing Several Pairs Of identical Socks Objectives/ Learning Goals:- • Direct objectives: Teaches the child how to pair and roll his/her socks • Indirect objectives: - Teaches the child to be independent - Develops problem solving and observation skills - Supporting the need for order with systematic use. - Improves co-ordination of movements - It promotes hand-eye coordination Control of Error:- None Age range:- 3 upwards Adult/Child ratio:- 1:1 Date of Lesson:- June 6th,2014 Time of Lesson:- 2pm Anticipated Duration:- 10 minutes Actual duration:- 27 minutes (+20 min observation) Setting:- Home Environment Pre-requisites:- • understanding of the cycle of activity • Knows where to find socks • Knows how to put on socks Advanced preparation for the lesson: - Place several identical and paired clean socks and place into a Basket/Tray • Find an appropriate location in the ‘Activities of Everyday Living’ area of the environment. • Familiarise yourself with the activity and steps involved. Step-by-step guidelines:- • This is an individual presentation. • Introduce the activity at the shelf, name it and link to the child’s prior learning (if appropriate). • Have the child place it on the table and Let the child know he will have a turn • Take one pair at a time out of the basket and unfold. • Place socks at random using slow...

Words: 1501 - Pages: 7

Free Essay

5 Lessons from a Dog

...5 Lessons from a Dog In Secrets of a Working Dog by Ellen Galvin and Patrick Galvin, Bella the Boxer outlines these canine principles of success in this dog-eat-dog world. Dogs have a protocol for playtime. When they’re ready to play, they stick their butts in the air, plop their front legs on the ground and prick up their ears. Take some time out of your day to unwind, but take the necessary steps to ensure that it’s scheduled productive play, not simply a waste of time. Become a better listener by wagging your tail more than your tongue. Great listening skills is an integral part of being a good communicator and leader. Many times, a frustrated individual just needs someone to listen to them, not necessarily to offer advice. Learn what your audience’s listening needs are to lend an open ear. Assemble your pack. The most successful people are those who surround themselves with a network of colleagues, mentors and good friends. And if you don’t want to catch any fleas, a good place to start is to surround yourself with people whose habits you would like rubbed off on you. “There are two kinds of people—those who come in a room and say, ‘Well, here I am’ or those that come in a room and people say “There you are.” Dogs are great at making us feel needed and valued, a trait we should learn to pass on to coworkers, employees or family. Enjoy the simpler things in life. Whether it’s taking the time to sniff the flowers or enjoying the wind in a car ride, dogs have a genuine...

Words: 303 - Pages: 2

Premium Essay

In Basket

...This assignment was designed put us, the student in a situation where we are placed in the supervisor position. In this assignment put the supervisor in a position of having to pick and choose what tasks to do themselves and what tasks should be delegated out after coming in and finding their basket full of tasks that need to be dealt with. When you obtain the position of supervisor, there is usually far too much for just you to do, therefore it is important to learn what to delegate and who to delegate it to. The most important tasks should be done by the supervisor but as far as things such as someone’s vacation hours and stocking merchandise for the store, those tasks should be delegated out to the assistant manager and to the store clerks. Being a supervisor means being in a role of leadership, logic, common sense, and decision making for yourself, the employees, and for the company. The “in Basket” debate and discussion gives us and our fellow classmates the opportunity to see if we can successfully delegate out certain tasks as a supervisor at a fictitious company. The discussion between me and fellow classmates was a great one and it appeared as though everyone agreed on everything accept for different incidents. The only two incidents where I came across disagreement were in regards to task number 3, and task number 4. These are the examples in which I will be using in this paper as far as disagreeing is concerned. Task number 3 is in regards to the mall hours changing...

Words: 848 - Pages: 4

Premium Essay

Just Do It

...question number 4, if answered Public Transportation please go to question number 5.) 4.) How likely are you willing to carpool? a. Very likely b. Likely c. No change d. Less likely e. Not likely at all 5.) Do you shop at other outlets in the area? If yes please answer question number 6, if no go to question number 7. a. Yes b. No 6.) Please rank the shopping centers from best to worst – (with 1 representing the best) Paragon Outlets Hacienda Shopping Center Stoneridge Mall Livermore Plaza 7.) I will be stopping at Paragon outlets instead of the other malls in the area. a. Strongly agree b. Agree c. Somewhat agree d. Disagree e. Strongly disagree 8.) Why would you shop at the Outlet? a. Shopping b. Food c. Entertainment d. Other 9.) When will you be visiting the Outlet? a. Morning b. Lunchtime c. Afternoon d. Evening e. Weekend 10.) How many times do you visit a mall or shopping center in a month? a. 0-1 b. 2-5 c. 6-9 d. 10-14 e. 15+ 11.) Do you believe there is a benefit shopping at a mall vs. at local stores a. Yes b. No c. Don’t shop at local stores 12.) Impact of Outlet on online shopping a. Less Likely b. No effect c. More Likely d. No Answer 13.) On a scale of 1 to 5 rate if you think the...

Words: 562 - Pages: 3

Premium Essay

Student

...Customer number 1 Interested in a Camera Photo • What is your age? 38 • What is your gender? Male • What is your household size? 2 people • What is your household income? $40,000.00 • What is your profession? Handling heavy machinery • What is your education level? High School Diploma Psychographic Questions • What did you find interesting about this product? It’s capability of taking photos • What are your thoughts about the product? It has a great resolution Buying Pattern Questions • Do you ever purchase electronics? YES • Where do you go when you are looking for electronics? On Web • How often do you purchase electronics? Once in a while • How long does it take you to make a buying decision? A few days • What is your typical budget for electronics? $200-$500 • How far would you travel to make the purchase? Around Windsor Benefits Questions • What features do you look for when you purchase electronics? Its quality • What specific benefits do you look for in electronics? Reliability • What motivates you to purchase electronics? Universal Trend • What needs are you trying to meet when you purchase electronics? Enhancing lifestyle • How do you hope electronics will make your life better? Time saving Customer Number 2 Interested in a gaming console • What is your age? 22 • What is your gender? Male • What is your household size? 4 people • What is your household income? $30,000.00 • What is your profession? Student • What is your education...

Words: 2014 - Pages: 9

Premium Essay

Cross Curricular Learning

...Introduction Cross Curricular teaching involves a conscious effort to encourage students to apply skills or knowledge acquired through learning at school to more than one subject on their curriculum. A central topic or theme can interlink subjects with each other, and students as a result should be able to learn an aspect of a central topic and apply information learned in one subject to others(Householder & Boulin 1992). As mentioned in Component 1 there are huge advantages to Cross Curricular teaching and learning. However, many students do not or cannot apply the knowledge that they have acquired in one subject to others (www.fromtinyacorns.wordpress.com/2009/10/28/about-transdisciplinary-thematic-learning) Learning beyond subject boundaries provides a student with the opportunity to experience not only learning that is relevant to one subject’s requirements, but also learning information that they will apply to other subjects. This type of learning some students may find to be challenging as they will be studying one topic from many different perspectives. However, with a deeper understanding of a topic, others will find it more interesting and may be encouraged to study the topic even further. Rensick (1989) confirms this stating that in contrast to learning topics in isolation students become more actively engaged in their studies when they participate in cross curricular learning. Cross curricular learning that is based on linking learning experiences and...

Words: 3118 - Pages: 13

Premium Essay

Multicultural Lesson Plan

...Lesson Plans Lesson plans will be filled out on how to use Dolch words to help improve reading. 1. Are the objectives aligned with academic standards? Yes State how the lesson objectives support the academic standards. The lesson will help students in grades Pre-K, K and 1st to understand how to read. 2. Are the assessments aligned with the objectives? Yes Is it explicitly clear what the students should know and be able to do by the end of the lesson? Yes, the students should know a certain number of dolch words by a certain date. What is the evidence demonstrating mastery of knowledge and/or skills that will support the lesson objectives? Documentation of the words correct on paper. 3. Are the learning experiences relevant to the objectives? Yes 4. Is instruction differentiated? Yes, EEL and Special Education students will have flash cards, I-pads to help pronounce the words, memory match. How will ELL or special needs students benefit from these lessons? To help them build up their vocabulary by learning the basic and more frequent words. Name the activities that support learning modalities, gender, or cultural groups. 5. Are there frequent and multiple ways to check for understanding during instruction? List the strategies to check for understanding. Include other strategies not in the lessons that could be utilized to further check for student understanding. • Spelling test • Memory test • Flash card • Reading probes • Printable worksheets ...

Words: 469 - Pages: 2

Premium Essay

Vietnam Legacy Lesson Plan

...DEMO LESSON Lesson Plan in Language in Literature II Afro-Asian Literature I. Subject Matter: Vietnam Legacy Reference: Language in Literature Afro-Asian Literature (p. 156) Materials: illustration boards, Multimedia materials Time Frame: 2 Meetings II. Objectives A. Generate responses to a question the poem asks about giving tributes to fallen soldiers B. Identify imageries in the poem C. Demonstrate comprehension on the poem by giving accurate answers to questions D. Enumerate ways how they can promote peace in their own little ways as students. III. Lesson Proper A. Introduction 1. Through a DLP, show pictures of soldiers. Let students verbalize their ideas about the pictures. 2. Inform them that they are about to read a poem about soldiers. 3. Post the following question to be answered towards the end of the lesson: What is the best way to remember those who fought in a war for freedom? B. Interaction 4. Let students read the poem silently, then let them read it aloud in chorus with the poem projected through DLP. 5. Instruct them to locate the following unfamiliar words on the poem, then give their definitions: * Granite- a very hard rock used in building * Engraved- carved into a block or surface * Relive- To undergo or experience again, especially in the imagination. * Laureate- a person who has been honored for achieving distinction in a particular field or with a particular award...

Words: 585 - Pages: 3

Premium Essay

Answers to Lessons 4&5

...volumes P 107 5. FAT32 P 111 6. Checksum P 137 7. DiskPart P125 8. Administrators or Backup Operators P 122 9. MBR P 111 10. Widows Hardware Quality Lab P 139 TRUE/FALSE 1. FALSE 2. FALSE 3. TRUE 4. FALSE 5. TRUE 6. FALSE 7. TRUE 8. TRUE 9. FALSE 10. TRUE REVIEW QUESTIONS 1. Both spanned volumes and striped volumes utilize storage space of 2 to 32 disks. The difference between the two is that spanned volumes fill up the space on one disk at a time, while striped volumes write one strip at a time to each disk in sequence. Neither method provides fault tolerance because there is no redundant data. However, striped volumes provide better performance than spanned volumes because the sequential disk reads and writes are more efficient than those on a single drive. P 110 versions, 2. Manufacturers typically release driver updates to address problems with previous driver, enhance device performance, or add new features. 137 CASE Scenarios Because you can’t see the display, the only thing you can do is turn off the computer and restart it .Press F8 as the computer starts and select Safe Mode from the boot menu. This loads the operating system with a genic VGA display driver that enables you to at least see the interface. Open Device Manager and use the Roll Back feature on the Driver tab of the video adapter’s Properties sheet to remove the problematic driver you just installed and return to previous version. P143. LESSON 5 FILL IN THE...

Words: 593 - Pages: 3

Free Essay

Lesson Plan

...LESSON PLAN Activity:Volleyball Grade: High School Date: 1/31/14 Name. Objectives: Number of Students:30 1. (Psychomotor) Students will demonstrate proper form of a Forearm Pass through repetition. Equipment Needed: balls, net Play Space Needed: court 2. (Cognitive) Students will show proper understanding of a Forearm Pass through peer teaching. Special Markings: front court, back court CALIFORNIA SKILL AREAS: 1. Sensorimotor and perceptual motor 2. Locomotor 3. Non-locomotor 4. Balance 5. Eye-hand coordination 6. Eye-foot coordination 7. General coordination 8. Creative movement NASPE CONTENT STANDARDS IN PHYSICAL EDUCATION – a physically educated person: 1. Demonstrates competency in motor skills and movement patterns needed to perform a variety of physical activities 2. Demonstrates understanding of movement concepts, principles, strategies, and tactics as they apply to the learning and performance of physical activities 3. Participates regularly in physical activity 4. Achieves and maintains a health-enhancing level of physical fitness 5. Exhibits responsible personal and social behavior that respects self and others in physical activity 6. Values physical activity for health, enjoyment, challenge, self-expression, and/or social interaction Time Description of Skills and Activities Student Teacher Organization Formations Teaching Cues...

Words: 463 - Pages: 2

Free Essay

Lesson from Geese

...Lessons from Geese 'Individual empowerment results from quality honking' Lessons from Geese provides a perfect example of the importance of team work and how it can have a profound and powerful effect on any form of personal or business endeavor. When we use these five principles in our personal and business life it will help us to foster and encourage a level of passion and energy in ourselves, as well as those who are our friends, associates or team members. It is essential to remember that teamwork happens inside and outside of business life when it is continually nurtured and encouraged. Lesson 1 - The Importance of Achieving Goals as each goose flaps its wings it creates an UPLIFT for the birds that follow. By flying in a 'V' formation the whole flock adds 71 percent extra to the flying range. Outcome When we have a sense of community and focus, we create trust and can help each other to achieve our goals. Lesson 2 - The Importance of Team Work When a goose falls out of formation it suddenly feels the drag and resistance of flying alone. It quickly moves back to take advantage of the lifting power of the birds in front. Outcome if we had as much sense as geese we would stay in formation with those headed where we want to go. We are willing to accept their help and give our help to others. Lesson 3 - The Importance of Sharing when a goose tires of flying up front it drops back into formation and another goose flies to the point position. Outcome It pays to...

Words: 397 - Pages: 2

Free Essay

Fnt1

...Lessons from Geese 'Individual empowerment results from quality honking' Lessons from Geese provides a perfect example of the importance of team work and how it can have a profound and powerful effect on any form of personal or business endeavor. When we use these five principles in our personal and business life it will help us to foster and encourage a level of passion and energy in ourselves, as well as those who are our friends, associates or team members. It is essential to remember that teamwork happens inside and outside of business life when it is continually nurtured and encouraged. Lesson 1 - The Importance of Achieving Goals as each goose flaps its wings it creates an UPLIFT for the birds that follow. By flying in a 'V' formation the whole flock adds 71 percent extra to the flying range. Outcome When we have a sense of community and focus, we create trust and can help each other to achieve our goals. Lesson 2 - The Importance of Team Work When a goose falls out of formation it suddenly feels the drag and resistance of flying alone. It quickly moves back to take advantage of the lifting power of the birds in front. Outcome if we had as much sense as geese we would stay in formation with those headed where we want to go. We are willing to accept their help and give our help to others. Lesson 3 - The Importance of Sharing when a goose tires of flying up front it drops back into formation and another goose flies to the point position. Outcome It pays to...

Words: 397 - Pages: 2

Free Essay

Ubd Lesson Plan

...|Name: Gail Faulkner |Date:4-22-2012 | |Unit Title: the study of Water | |Grade Level: PRE-K | |Subject: Science | |Unit Length: 10 minutes | |Brief Summary of Unit | |(Describe the context for this unit within the curriculum, and the curricular aims of the unit.) | | | |What understandings or goals will be assessed through this task? (Students will…) | | | |Will understand how water is a way of life for people. They will also gain recognition of various types of things we use water for.| |The students will develop...

Words: 1904 - Pages: 8

Free Essay

Indigestion and Titration: an Acid-Base Titration

...0 g Tums 21.0 g Mylanta 18.0 g CVS brand 18.3 g Rennies 17.5 g 24.1 mL 22.4 mL 20.0 mL 19.9 mL 24.4 mL 1. Which is the strongest antacid, on a single-dose basis? Which is the weakest? Explain and show your calculations. 2. Which are the strongest and weakest, on a by-weight (mass) basis? 3. When people do back titrations, they usually watch the solution for a color change when the solution becomes neutral. What might you have used in the above experiment to get this color change to happen in the solution? At what pH would the solution have been neutral? 4. If you had walked into the lab, only to discover that you only had 0.1 M sulfuric acid available to run your tests, how might this have affected your calculations? Why? 5. In...

Words: 1292 - Pages: 6

Free Essay

Spring 2013

...Spring 2013 Assignment Ongoing Task: A. Use a news reporter to find headlines for each of the following lessons. Make sure that the headline is school appropriate, relevant to each lesson, and cited using MLA format. Lesson 1: Introduce the environment. Lesson 2: Identify the problem. Lesson 3: Identify the solutions. (What tools are available to perform the project?) Lesson 4: Evaluate the solutions. (If there are assumptions, what are they?) Lesson 5: Evaluate the ethical and social issues. (What ideas are compatible or incompatible with the problem and solutions?) Lesson 6: Propose the best solution. Lesson 7: Conclude your project experience. B. Write one paragraph for each of the above lessons. The lessons are directed to someone who has no experience in the field. Each lesson should be completed by the assigned due date. One Time Development: (This is a combination of the ongoing task.) A. In a term paper format (two+ pages), provide a formal proposal for the project analyzing the following (bring together all the lessons you worked on throughout the course): 1. The Problem 2. The Solutions Identified 3. The Solutions Evaluated 4. The Ethical and Social Issues 5. The Best Solution B. This paper will be traded with one assigned group member after receiving my feedback for editing improvements. Each student will read the assigned proposal, name 3 positive comments, ask...

Words: 293 - Pages: 2