ExamGecko
Question list
Search
Search

List of questions

Search

Question 3 - Desktop Certified Associate discussion

Report
Export

Connect to the 'Global Superstore' data source and use the Orders table. Find out the customers who placed their first order in 2013 and what is the total sales value of these customers in the same year?

A.
$414,302
Answers
A.
$414,302
B.
$2,263,137
Answers
B.
$2,263,137
C.
$483,269
Answers
C.
$483,269
D.
$2,385,198
Answers
D.
$2,385,198
Suggested answer: C

Explanation:

Find the minimum order date for each customer

Drop the order date, Min Order date, and Sales to the view

$2,263,137 is the sales value in 2013 of the customers who placed their first order in 2013.

asked 23/09/2024
Tshimangadzo Mbulawa
35 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first