Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

The following is a valid sql statement

22/10/2021 Client: muhammad11 Deadline: 2 Day

Data Analyst Questionnaire
Within this document are four different questions. Each question is structured in the following manner:

1) Premise - Contains any needed background information

2) Request - The actual question, what you are to solve

3) Notes - A space if you feel like including notes of any kind for the given question

Please place your answer for each question in a separate file, following this naming convention:

FINRA_Qn.docx, where n = the question number (i.e., 1, 2 ...). So the file for the first question should be named ‘FINRA_Q1.docx’.

When complete, please package everything together and send email responses to the designated POCs.

Page | 1 FINRA

Premise: You have a table named “TRADES” with the following six columns:

Column Name

Data Type

Description

Date

DATE

The calendar date on which the trade took place.

Firm

VARCHAR(255)

A symbol representing the Broker/Dealer who conducted the trade.

Symbol

VARCHAR(10)

The security traded.

Side

VARCHAR(1)

Denotes whether the trade was a buy (purchase) or a sell (sale) of a security.

Quantity

BIGINT

The number of shares involved in the trade.

Price

DECIMAL(18,8)

The dollar price per share traded.

You write a query looking for all trades in the month of August 2019. The query returns the following:

DATE

FIRM

SYMBOL

SIDE

QUANTITY

PRICE

8/5/2019

ABC

123

B

200

41

8/5/2019

CDE

456

B

601

60

8/5/2019

ABC

789

S

600

70

8/5/2019

CDE

789

S

600

70

8/5/2019

FGH

456

B

200

62

8/6/2019

3CDE

456

X

300

61

8/8/2019

ABC

123

B

300

40

8/9/2019

ABC

123

S

300

30

8/9/2019

FGH

789

B

2100

71

8/10/2019

CDE

456

S

1100

63

Questions:

1) Conduct an analysis of the data set returned by your query. Write a paragraph describing your analysis. Please also note any questions or assumptions made about this data.

The result shows that the majority of the shares were sold on the 9th and 10th of August(3200), leading to highest price traded per share. CDE firm on average, trades more than any other firm

2) Your business user asks you to show them a table output that includes an additional column categorizing the TRADES data into volume-based Tiers, with a column named ‘Tier’. Quantities between 0-250 will be considered ‘Small’, quantities greater than ‘Small’ but less than or equal to 500 will be considered ‘Medium’, quantities greater than ‘Medium’ but less than or equal to 500 will be considered ‘Large’, and quantities greater than ‘Tier 3’ will be considered ‘Very Large’ .

a. Please write the SQL query you would use to add the column to the table output.

b. Please show the exact results you expect based on your SQL query.

3) Your business user asks you to show them a table output summarizing the TRADES data (Buy and Sell) on week-by-week basis.

a. Please write the SQL query you would use to query this table.

b. Please show the exact results you expect based on your SQL query.

Notes:

1

Premise: You need to describe in writing how to accomplish a task. Your audience has never completed this task before.

Question: In a few paragraphs, please describe how to complete a task of your choice. You may choose a task of your own liking or one of the sample tasks below:

1) How to make a peanut butter and jelly sandwich

2) How to get leaves off a lawn

3) How to make a cup of tea

Notes:

Let's consider the task - How to make a cup of tea.

To accomplish this task, we first need to avail the items needed to make tea, like tea leaves, milk, sugar and some water. Now we can make tea following the below steps :

1) Put water into a kettle or saucepan.

2) Heat the water. Different types of temperature for brewing.

3) Put tea leaves into the hot water. For 1 cup tea, place 1 tablespoon loose tea leaves.

4) Steep the tea according to tea type.

5) Strain tea leaves.

6) If you want to add milk, add it after pouring the tea in cup and stir gently.

7) Add sugar to taste.

Tea is now ready.

For any task to be accomplished, we should go with step by step procedure, so that it's easy to proceed with.

2

Premise: Below is a snapshot of data from two tables: “Orders” and “Customers”, taken on 02/05/2016. You find the following documentation:

· The ORDERS table gets updated at the end of every day

· The CUSTOMERS table gets updated at the end of every week

ORDERS Table

Field Name

Description

ORDER_DT

Date the order was placed.

ORDER_ID

A unique identifier for each order.

ORDER_STATUS

The status of an order.

CUSTOMER_ID

Identifies a unique customer.

CUSTOMERS table

Field Name

Description

CUSTOMER_ID

The unique identifier of the Customer trading in the market

CUSTOMER_STATUS

The Customer's account status. It should be ‘Active’ in order to be eligible for Order processing.

CUSTOMER_FNAME

First name of a customer.

CUSTOMER_MNAME

Middle name of a customer.

CUSTOMER_LNAME

Last name of a customer.

GENDER

Gender of a customer.

AGE

Age of a customer.

Table Name: ORDERS

ORDER_DT

ORDER_ID

ORDER_STATUS

ORDER_STATUS_CD

CUSTOMER_ID

2/1/2016

1000002

Completed

S

4

2/2/2016

2000008

Processing

P

6

2/2/2016

2000009

Completed

S

7

2/2/2016

2000010

Completed

S

7

2/3/2016

3000008

Processing

P

6

2/3/2016

3000009

Cancelled

C

6

2/3/2016

3000010

Cancelled

C

4

2/3/2016

3000011

On Hold

H

3

2/3/2016

3000012

Processing

P

7

2/4/2016

4000005

Completed

S

6

(Continued on next page)

Table Name: CUSTOMERS

CUSTOMER_ID

STATUS

FNAME

MNAME

LNAME

GENDER

AGE

1

Active

John

Smith

M

70

2

Active

James

Emitt

Madison

M

68

3

Active

Joe

Anthony

Diggs

M

55

4

Inactive

Adam

Lambert

M

40

5

Active

Marcus

Dallas

M

81

6

Active

Steve

Eugene

Bullock

M

62

7

Active

Naomi

Patel

F

33

8

Active

Alexander

Pope

M

29

9

Inactive

Peter

Chandler

M

36

Any coding language can be used to query the data.

Question:

1) Your business user asks you to combine the details from these two tables in one table output, without any duplicated columns.

A. Please write the query you would use to query this (note which language you are using).

SELECT ORDERS. CUSTOMER_ID, ORDERS.ORDER_DT, ORDERS. ORDER_ID, Orders. ORDER_STATUS_CD

CUSTOMERS.STATUS, CUSTOMERS.FNAME, CUSTOMERS.MNAME, CUSTOMERS.LNAME, CUSTOMERS.GENDER, CUSTOMER.AGE

FULL OUTER JOIN ORDERS ON CUSTOMERS.CUSTOMERS_ID=ORDERSCUSTOMERS_ID;

B. Please show the exact results you expect based on your SQL query.

C. If you make assumptions to complete the task, please document them.

2) Through an investigation, your business user has learnt that there has been an order that was processed successfully by mistake.

A. Please write the query you would use to validate (or disprove) this finding (note which language you are using).

B. Please show the exact results you expect based on your SQL query.

C. If you make assumptions to complete the task, please document them.

Notes:

Premise: The following are stand-alone SQL questions. If you are unable to answer a question, please document your approach and proposed next steps. For each of the below, please show the exact results that you expect based on your SQL query.

Question:

1) Is this a valid SQL statement?

SELECT CUSTOMERS.GENDER, count(DISTINCT CUSTOMERS.CUSTOMER_ID), count(*), sum(DISTINCT CUSTOMERS.CUSTOMER_ID)

FROM CUSTOMERS

GROUP BY CUSTOMERS.GENDER;

2) Is this a valid SQL statement?

SELECT CUSTOMERS.GENDER, count(DISTINCT CUSTOMERS. CUSTOMER_ID), count(*), count(DISTINCT CUSTOMERS.AGE)

FROM CUSTOMERS

GROUP BY CUSTOMERS.GENDER;

Notes:

1. Yes it is a valid statement as we are counting the number of persons of specific gender but there is no need of summing up the customer id's and also the customer id's are unique so there is no need of applying distinct on id.

2. This is also a valid statement as we are grouping up by genders and counting the persons with different ages.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Engineering Solutions
George M.
Essay & Assignment Help
Solutions Store
University Coursework Help
Instant Homework Helper
Writer Writer Name Offer Chat
Engineering Solutions

ONLINE

Engineering Solutions

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$37 Chat With Writer
George M.

ONLINE

George M.

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$29 Chat With Writer
Essay & Assignment Help

ONLINE

Essay & Assignment Help

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$40 Chat With Writer
Solutions Store

ONLINE

Solutions Store

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$22 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

I have read your project details and I can provide you QUALITY WORK within your given timeline and budget.

$23 Chat With Writer
Instant Homework Helper

ONLINE

Instant Homework Helper

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$15 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

General endotracheal anesthesia cpt code - Xamarin free vs paid - Business law - Client change scale - Use case diagram for grocery store - Complete Analysis of a System - Chloroplasts contain disklike membranous sacs arranged in stacks called - PROJECT PURPOSE STATEMENT AND PROBLEM STATEMENT - Week 6 Discussion - Overexposure in digital radiography - Pre engineered metal building weight - Need help with report. - Distance between bridge supports - Pip short film theme - Premier's reading challenge login - Human Resources - Balance sheet statement of retained earnings - DISCUSSION REPLY - Engineering student cover letter - Iprofile nutrition software free - Collaboration diagram for student registration system - Should vaccines be mandatory essay - Case 1: Volume 2, Case #16: The woman who liked late-night TV - Training - Swot analysis of volkswagen company - Iso 5817 level d - Charlie in jasper jones - State adoption resource agency - Making pronouns and antecedents agree - Tweetdeck comn - Marcum showdown troller 2.0 problems - Wk3 ASSIGN 6053 - 3 spheres of project management - What you pawn i will redeem analysis - Federal public service mobility and transport - Best book for behavioral science step 1 - Human resource test - What is a presentation expert at target - Nursing interventions for kussmaul respirations - Respect for acting author hagen - Earthquake in Haiti - Best topics to talk about in a speech - Click and learn virus explorer answers - Future of Informatics - Metarteriole and thoroughfare channel - Discussion - Thomson's charge to mass ratio - Education - Difference between glacial acetic acid and dilute acetic acid conductivity - School Counseling PPT - Bay sheffield prize money - Powerpoint - Excerpt from the jungle answers - Vision mission and strategy of coca cola - Career Planning and Management - Potter and perry fundamentals of nursing 9th edition apa citation - Joe montoya senior center flagstaff - 90/90 hamstring flexibility test norms - What are inherent requirements - Cost per occupied room spreadsheet - Corwin corporation case study - 4 pics 1 word pulley fishing soccer - Forklift safe work procedure - 20c leinster grove brunswick east - Advantages of causal research - Nsw rfs uniform protocol manual - End of day checklist - Mary porter traditional school - Types of compass surveying - Anterior spinothalamic tract decussation - Nanda nursing diagnosis for umbilical hernia - As3000 earth stake depth - Human Resource - Velodyne subwoofer repair manual - Manchester medical school curriculum - Mawson primary school reviews - Week 6 part 2 plagiarism - Advanced Ergonomics - College english and business communication 11th edition - Bimetallism vs gold standard - 15 page powerpoint slide - Discussion forum - Jekyll and hyde chapter 6 - Discussion 5 - Math 1025 - On course journal entry 7 - Executive Summary - Sissy strong fitness body guide pdf - A successful blue ocean strategy requires - Go to quiz personality plus - The resiliency model of case management refers to - Para lavarse el pelo carlos usa crema de afeitar - Https www procon org debate topics php - Highest Custom Whiteboard Animation Video Maker - Cummings and worley organization development and change pdf - The primary purpose of a cash budget is to - Schedule 8 drugs wa - SPEECH 101 - Sex without love poem theme - 3rd order rate law