Show everything in the customer table.
First select the database bank. Answer the following questions using SQL query codes. After each question, provide your SQL query. You can submir a Word file, pdf file. Make sure you include the question number for each SQL query.Attached document is an example for you to follow
- Show everything in the customer table. (1pt)
- Show the first and last name of all customers. (1pt)
- Show all the DIFFERENT nationalities of the customers. (1pt)
- Show the names (first and last name) of the customers and their annual income. Sort the results in descending order by income. (1pt)
- Show all the customers (first and last name) whose last name is Barrows. (1pt)
- Show all the customers (first and last name) whose nationality is NOT Japan. (1pt)
- Show all the customers (first and last name) whose birth year is between 1970 and 1980. (1pt)
- Show the customers (first and last name) whose household size is greater than or equal to 6. (1pt)
- Show the customers (first and last name) whose email address ends with “com”. (1pt)
- Show the customers (first and last name) whose language is EITHER Chinese (cn), French (fr), English (en) OR Italian (it). (1pt)
- Show the customers (first and last name) from California (CA) that have annual income greater than $200,000. (2pt)
- Show customers (first and last name) that are born after (>) 1990 or have annual income less than $20,000. (2pt)
- Show the customers (first and last name) whose birth year is NOT between 1950 and 1990. (2pt)
- Show the customers (first and last name) that are from Texas(TX), Florida(FL), Indiana(IN) or Oregon(OR), AND has household size of less than 4. (2pt)
- Show the customers (first and last name) whose zipcode starts with 0, and are born after 1950. Sort the results in descending order by birth year. (2pt)
Encourage you to get out and observe what is around you and show you how the built environment can affect you.
The purpose of this assignment is to encourage you to get out and observe what is around you and show you how the built environment can affect you.
- Visit an architecturally significant site in your community. It may be a historic or contemporary building, or an urban space.
- Use drawings, diagrams, photographs, or any combination of the three, and written words to describe your observations.
- This project may be presented creatively (collage, figure/ground organization, Photoshop, poetry, etc).
- Remember a one page, 8 1/2″ x 11″ document format can be scanned and imported.
- Outline form is acceptable.
What was your favorite part of the film? Why?
Introduction
This week you are required to watch the film, “Crip Camp.” You can access the film here (Links to an external site.) for the captions option. (The embedded video doesn’t allow for captions)
(10) CRIP CAMP: A DISABILITY REVOLUTION | Full Feature | Netflix – YouTube
Discussion Board Requirements
- You are required to respond to the following questions. Your initial response must be thorough, and a minimum of 3-5 sentences for each question.
- Afterward, you are required to reply to three of your classmates. Your response must be at least 3 sentences and cannot simply say, “good job,” or “I agree with you,” etc… Your responses must be respectful of the opinions of others.
- To receive full points you must respond to the film and reply to three of your classmates.
Discussion Board Questions
- What was your favorite part of the film? Why?
- What thoughts or feelings came to mind as you finished the film?
- Did anything that happened in this movie remind you of something that has occurred in your own life or that you have seen occur to others? Be specific.
Calculate the Growth rate of GDP per capita for each of the countries in the years under consideration.
DATA ANALYSIS
Calculate the Growth rate of GDP per capita for each of the countries in the years under consideration. Show boxplots of incomes for all the countries in each year. What happened? Is there any evidence for convergence? Discuss the notions of conditional and unconditional convergence in this regard (Hint.: Use logs instead of levels).
● Split the data into two groups of poor and rich. The split should be done according to the median income in 1990. Then show boxplots of incomes for both groups in each year. What happened? Is there any evidence for convergence? (Hint.: Use logs instead of levels. Start with splitting the sample: poor in 1960, 1990, and 2020, then the same for the rich. Plot boxplots for each
COUNTRIES
In the world bank as of 2020 the top 5 richest countries are
1. Luxembourg
2. Switzerland
3.Ireland
4. Norway
5.USAs of 2020 poorest country as per world bank
1.Burundi
2.Somalia
3. Mozambique
4.Central African Republic
5.Sierra Leone
Prepare an essay on Jaundice
Topic- Jaundice.
Etiology- Include cause, predisposing factors, history contributing to disease process.
Assessment Findings Related to Disease Process- positive assessment findings that lead to illness and any differential diagnoses.
Diagnostics- any diagnostic tests which would reveal the diagnosis
Summarize the video. Include the history of the presidency, faith and the presidency, the media, etc.
Watch the video: https://www.c-span.org/video/?514165-1/role-presidency
Summarize the video. Include the history of the presidency, faith and the presidency, the media, etc.
Then, conclude with your overall thoughts.
Is there a requirement that all serious criminal charges set before they can be?
The question is, under the Florida State Constitution, is there a requirement that all serious criminal charges set before they can be? Charged formerly against a defendant, they have to be B. B has to be determined by grand jury. In other words, in Florida, under the state constitution is a requirement that a that a grand jury determines whether there’s probable cause with respect to all serious all serious criminal charges that would be under the State of Florida constitution.
Submit a brief justification for your final research paper topic.
This assignment requires you to submit a brief justification for your final research paper topic.
Professional justification is between 400 to 600 words and includes the following information:
1- A good title for your research paper
2- the problem under investigation
3- the importance of the study
4- the purpose of the study
5- main participants in your study (for example, if you have any case, you need to introduce here)
Creating something? Cooking something? Making something? Do not try to embellish your writing. Write about the action as if you were doing a play-by-play.
Assignment: You are to watch a person perform a task, and write what you observed. You should tell only what happened; do not include yourself in the action, but simply watch someone LIVE do an action of some kind. Be sure to focus on the physical activity and on how the individual is doing it (step by step). Lifting something? Building something? Creating something? Cooking something? Making something? Do not try to embellish your writing. Write about the action as if you were doing a play-by-play.
Checklist:
- Write the story as an observer and not participant in the scene.
- Do not try to describe how people feel or what they may think about. Simply write about what you can see and hear.
- Do not write a scene for a novel, short story or film.
- Do not use the personal pronoun “I”. Do not include yourself in the story.
- Do not refer to people by name. Use generic labels (a man, a woman, a girl, a boy, etc.) to describe them even if you know them.
- Start each sentence with a noun followed by a verb, and then an object.
- Use correct conventions of writing (paragraphs, punctuation, spelling, grammar).
- Word count: 200 words exactly.
- Assignment is written in Times New Roman 12pt single-spaced.
Topic selection & research questions
A topic of research should be chosen. It can be either a research paper or a startup concept. Once the topic is finalized, the draft research questions (based on which objectives of the study will be formed) must be developed (not more than three). Each selection must be discussed in detail with logic and rationale. Reasons for the topic should be discussed first followed by discussion on selection of each of the research questions.
