Q1: 1. How would you use GROUPING SETS to produce the same results as the following GROUP BY CUBE? SELECT state, productID, SUM(volume) FROM sales GROUP BY CUBE (state, productID) ORDER BY state, prod

/in /by

Q1:

1. How would you use GROUPING SETS to produce the same results as the following GROUP BY CUBE?

SELECT state, productID, SUM(volume) FROM sales GROUP BY CUBE (state, productID) ORDER BY state, productID

2. How would you show the sub totals for each week, for each state, and for each product? (No other totals or grand totals are required.) Suppose the table structure is

TABLE sales (productID VARCHAR, state CHAR(2), week DATE, volume INT)

3. Discuss the utility of grouping and group_id functions

Q2: Describe below how this code will work:

SELECT dt, region, revenue,

count(*) OVER (twdw) AS moving_count,

avg(revenue) OVER (twdw) AS moving_average

FROM moving_average_data mad

WINDOW twdw AS (PARTITION BY region

ORDER BY dt RANGE BETWEEN

‘7 days’::interval PRECEDING AND

‘0 days’::interval FOLLOWING

ORDER BY region, dt

Taking Sides: Clashing views on Psychological Issues/ Gantt Read Issue 3.1 from the Textbook: “Are violent Video Games Harmful to Children and Adolescents?” YES: Steven Gruel from: “Brief of Amicus Cu

/in /by

Taking Sides: Clashing views on Psychological Issues/ Gantt

Read Issue 3.1 from the Textbook: “Are violent Video Games Harmful to Children and Adolescents?”

YES: Steven Gruel from: “Brief of Amicus Curiae in Case of Brown v. Entertainment Merchants Association.” U.S. Supreme Court (2010)

NO: Patricia Millet from: “Brief of Amicus Curiae in Case of Brown v. Entertainment Merchants Association.” U.S. Supreme Court (2010)

Discussion Questions

1. Using information from both articles, discuss the evidence in support of the idea that violent video games harm children or cause them to be violent. How does Millett respond?

2. Many people have strong opinions about violent video games, but very few know much about the research. Ask some people you know what they think about violent games and then ask them to tell you what they know about the research and tell them what you learned from reading the articles. Write a brief analysis of your findings.

3. Is it possible that violent video games could be good for people? Explain.

IMPORTANT: Remember to closely follow the guidelines for written assignments in this course that are detailed in the Syllabus, which include (a) limit the length of the post (250 words including references – please write the actual number of words at the end of your post), (b) check to make plagiarism free, (c) APA style of citation and referencing, and (d) use of complete sentences and capitalization (this is not a text message board).

Just need the minimizing cost done in the document. Please i had a tutor do it, but not based on the diagram I sent. Please review the document, and I will pay what is needed. ( I will also need “The

/in /by

Just need the minimizing cost done in the document. Please i had a tutor do it, but not based on the diagram I sent. Please review the document, and I will pay what is needed. ( I will also need “The total number of miles the pipeline will cover.”)

I NEED HELP IN EXAM I WILL PROVIDE STUDY MATERIAL . PDF FILE FOR STUDY YOU CAN FIND ANSWER FROM STUDY FILE

/in /by

I NEED HELP IN EXAM I WILL PROVIDE STUDY MATERIAL . PDF FILE FOR STUDY YOU CAN FIND ANSWER FROM STUDY FILE

A dam is used to block the passage of a river and to generate electricity. Approximately 5.73 ́ 104 kg of water fall each second through a height of 19.6 m. If 85 % of the gravitational potential ene

/in /by

A dam is used to block the passage of a river and to generate electricity. Approximately 5.73  ́ 104 kg

of water fall each second through a height of 19.6 m. If 85 % of the gravitational potential energy of the

water were converted to electrical energy, how much power would be generated?

Instructions You are about to reach the end of your capstone journey. You have completed drafts of your agency needs assessment and your findings and recommendations report, and you started developing

/in /by

Instructions

You are about to reach the end of your capstone journey. You have completed drafts of your agency needs assessment and your findings and recommendations report, and you started developing your personal and professional reflection. This week, you will complete your reflection, incorporate all feedback from the previous milestones, and put all three components together into a polished submission.

For additional details, refer to the Final Project Guidelines and Rubric document and the Capstone Project Template document.

Also, 100% free of plagiarism and completed on time! 

Successful completion of a doctoral dissertation requires significant amounts of independent reading on the research topic. This allows the doctoral learner/researcher to become familiar with the scop

/in /by

Successful completion of a doctoral dissertation requires significant amounts of independent reading on the research topic. This allows the doctoral learner/researcher to become familiar with the scope of the topic and to identify gaps or tensions within the existing literature on the topic. These gaps and tensions become the source of the dissertation research. In this assignment, you will read and annotate potential sources in your dissertation field of interest. Those demonstrating the most merit to the best of your understanding of the topic at this time should be added to your tracking software (i.e., Refworks) list for potential inclusion in the literature review section of your dissertation.

General Requirements:

Use the following information to ensure successful completion of the assignment:

  • Locate the assignment submission for “Literature Review Resources” from PSY-802. You will be adding to this document to begin building a running literature review.
  • It is strongly recommended that you engage in this activity throughout the duration of your program.
  • Instructors will be scoring your submission based on the number of unique sources identified in the list submitted.
  • Download the resource Literature Review Resources Tool and use it to complete the assignment.
  • Doctoral learners are required to use APA style for their writing assignments. The APA Style Guide is located in the Student Success Center.
  • Refer to Chapters 2-4 of the Publication Manual of the American Psychological Association (6th ed.) for specific guidelines related to doctoral-level writing. These chapters contain essential information on manuscript structure and content, clear and concise writing, and academic grammar and usage.
  • Refer to the resource, “Preparing Annotated Bibliographies,” located in the Student Success Center, for additional guidance on completing this assignment in the appropriate style.

Directions:

Read at least 10 peer-reviewed articles in your general dissertation field that you have not read previously.

In the “Literature Review Resources” document that you submitted in PSY-801, provide the following for each source that you are adding to the document:

  1. The APA-formatted citation.
  2. A brief annotation of the key points of the source.
  3. An indication of whether the source has been added to (Y) or excluded from (N) your tracking software (i.e., Refworks) list.

Highlight the additions to the document so your instructor can readily identify them.

AttachmentsPSY-803.R.LiteratureReviewResources.docx

Due Date: 22-Apr-2020 at 11:59:59 PM

Maximum Points: 50.0

Do Trans-Humanism and Traditional Religion agree on the possibility of an un-embodied or disembodied personality? If so, why?

/in /by

Do Trans-Humanism and Traditional Religion agree on the possibility of an un-embodied or disembodied personality? If so, why?