ExamGecko
Question list
Search
Search

List of questions

Search

Question 1 - Desktop Certified Associate discussion

Report
Export

Connect to the 'Global Superstore' data source and find out which 'Customer Name' (ignore the customer ID) has returned the highest percentage of his\her orders?

A.
Michael Oakman
Answers
A.
Michael Oakman
B.
Daniel Lacy
Answers
B.
Daniel Lacy
C.
Greg Tran
Answers
C.
Greg Tran
D.
Yoseph Carroll
Answers
D.
Yoseph Carroll
Suggested answer: B

Explanation:

Left join the Orders and Returns table

Number of orders returned will be order ID from the returns table divide by total orders

Drop the customer name and ret order field in the view.

asked 23/09/2024
Kameron Katoku
47 questions
NextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first