How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask Scott Your Own Question

Scott
Scott, MIT Graduate
Category: Homework
Satisfied Customers: 3040
Experience:  MIT Graduate (Math, Programming, Science, and Music)
3546829
Type Your Homework Question Here...
Scott is online now
A new question is answered every 9 seconds

Customer Question

Hi
Submitted: 1 year ago.
Category: Homework
Expert:  Cher replied 1 year ago.

Hi, and welcome!

My name is ***** ***** I will be glad to help with your question, if I am able.

All that came through is 'Hi,' so if you could provide details about your Homework question, it would be greatly appreciated!

Best regards,

Cher

Customer: replied 1 year ago.
I am currently taking Business Data Analysis final exam and there are three essay questions that I need help with. They come with reports. I am unable to copy/paste the report.36. (TCO 2) Refer to the tblCustomer table below. As a data analyst, you have been requested to select rows that meet the following requirements: List each customer name and their income for customers with a balance between 300 and 600. The customer name will be in the format of last name and first letter of first name followed by a '.': Smith B. - give this column an alias. The income must be displayed with a $, commas around the thousands and two decimal places. Give this column an alias. Assume that the Income field is defined as a money data type.tblCustomer:CustID (PK)LastName FirstName Phone City Region Overdue Status* Preferred Income NumOrders Balance Birthdate
10Smith Bob(###) ###-####Orlando North
PaidY 10000 5 100 1/1/1978
12 Ramirez Jose(###) ###-####Apex South Paid Y 50000 16 600 2/8/1970
13 Washington Terrell(###) ###-####Sujour East [null] Y 20000 25 700 3/5/1985
15 Jones Bill(###) ###-####AxeCrossing West Unpaid Y 16900 2 500 12/1/1990
17 Morales Sandy(###) ###-####Orlando North Paid N 85000 90 400 8/3/1986
21 Principe Michelle(###) ###-####Apex South Paid N 94000 85 300 7/2/1974
23 Mavis John(###) ###-####Sujour East Unpaid Y 25000 26 600 3/5/1989
*Overdue Status indicates customers with a balance that is 30 or more days overduePart 1: Write the complete SQL statement needed to return the rows that meet these requirements.Part 2: What rows will be returned from this query? List the customer ID only of the rows to be returned.Part 3: What function did you use to format the income column? Explain why you used this function. List one other purpose of this function. (Points : 25)
SpellcheckerQuestion 37. 37. (TCO 3) Refer to the tblCustomer table below. As a data analyst, you have been requested to select rows that meet the following requirements: For each city, list the average income of customers in that city. Do not include customers with an Overdue Status of Unpaid. Order the rows in alphabetical order of city.
tblCustomer:CustID (PK)LastName FirstName Phone City Region Overdue Status* Preferred Income NumOrders Balance Birthdate
10Smith Bob(###) ###-####Orlando North
PaidY 10000 5 100 1/1/1978
12 Ramirez Jose(###) ###-####Apex South Paid Y 50000 16 600 2/8/1970
13 Washington Terrell(###) ###-####Sujour East [null] Y 20000 25 700 3/5/1985
15 Jones Bill(###) ###-####AxeCrossing West Unpaid Y 16900 2 500 12/1/1990
17 Morales Sandy(###) ###-####Orlando North Paid N 85000 90 400 8/3/1986
21 Principe Michelle(###) ###-####Apex South Paid N 94000 85 300 7/2/1974
23 Mavis John(###) ###-####Sujour East Unpaid Y 25000 26 600 3/5/1989
*Overdue Status indicates customers with a balance that is 30 or more days overduePart 1: Build your SELECT statement by choosing the clauses from the list below and putting the clauses in the correct order:SELECT Customer, Avg(Balance)
FROM tblCustomer
SELECT City, Avg(Income)
ORDER BY Avg(Income)
WHERE OverDueStatus = 'UnPaid'
GROUP BY Customer
HAVING OverDueStatus = 'UnPaid'
GROUP BY City
ORDER BY City
WHERE OverDueStatus = 'Paid'
HAVING OverDueStatus = 'Paid'Part 2: Did you select any filter clause(s)? (WHERE, HAVING) Justify your choice of filter(s). (Points : 25)
SpellcheckerQuestion 38. 38. (TCO 6) Evaluate the Employee Sales by Country report below. This report was requested by management so they could review employee sales data for certain countries at certain times.Part 1: Describe at least two enhancements that would make this report more readable to the user.Part 2: Describe at least two features you would include that would add functionality to the report and improve its flexibility for the user.
(Points : 25)
Spellchecker
Expert:  Cher replied 1 year ago.

Hi again, and thanks for including your complete question.

Unfortunately, this is not within my area of expertise, so I will opt out, returning your question to the open list for another expert to help you.

Much good luck with your assignment!

Best wishes,

Cher

Customer: replied 1 year ago.
Okay, thanks
Expert:  Cher replied 1 year ago.

No problem! : )

Customer: replied 1 year ago.
Can anyone help please?
Expert:  akch2002 replied 1 year ago.

Can you forward soft copy of the questions?