10 Questions
What is the total gross income for the customer with Invoice ID 373-73-7910?
The total gross income for the customer with Invoice ID 373-73-7910 is $30.2085.
What is the unit price of the product line 'Food and beverages' for the customer with Invoice ID 692-92-5582?
The unit price of the product line 'Food and beverages' for the customer with Invoice ID 692-92-5582 is $54.84.
On which date and at what time did the customer with Invoice ID 631-41-3108 make the purchase?
The customer with Invoice ID 631-41-3108 made the purchase on 3/3/2019 at 13:23.
What is the total amount paid by the customer with Invoice ID 355-53-5943?
The total amount paid by the customer with Invoice ID 355-53-5943 is $433.692.
What is the gender of the customer with Invoice ID 665-32-9167?
The gender of the customer with Invoice ID 665-32-9167 is Female.
What is the total amount paid by all customers in the branch 'Yangon'?
total amount = $548.9715 + 340.5255 + 489.048 + 634.3785 + 433.692 + 76.146 = $2522.7615
What is the average gross margin percentage for customers who paid using 'Ewallet'?
average gross margin percentage = $4.761904762 + 4.761904762 + 4.761904762 + 4.761904762 = $4.761904762
What is the total quantity of products purchased by male customers in the branch 'Yangon'?
total quantity = 7 + 7 + 8 = 22
What is the total COGS (Cost of Goods Sold) for all customers who made a purchase on 1/27/2019?
total COGS = $465.76
What is the average unit price of 'Electronic accessories' for customers who made a purchase using 'Credit card'?
average unit price = $85.39
Test your knowledge of retail sales data by analyzing invoice details such as invoice ID, branch, city, customer type, gender, product line, unit price, quantity, tax, total, date, time, payment, cost of goods sold (COGS), gross margin percentage, gross income, and rating.
Make Your Own Quizzes and Flashcards
Convert your notes into interactive study material.
Get started for free
