Scribd
Upload
18 views1 page

Cookie Sales and Profit Analysis

Questions for data analytics

Uploaded by

abdulganiyusimiyatu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
18 views1 page

Cookie Sales and Profit Analysis

Questions for data analytics

Uploaded by

abdulganiyusimiyatu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 1

AGGREGATION FUNCTIONS

Q1. What is the total number of cookies sold across all orders?
Q2. Find the count of total orders made.
Q3. Find the total number of distinct customers
Q4. Calculate the profit made by the cookie company.
Q5. What is the profit margin in percentage?
ITERATOR FUNCTIONS
Q6. From the Cookie Types table, find the profit made by the company.
LOGICAL FUNCTIONS
Q7. How many cookies were sold on each day of the week?
Q8. Find all the different products that contain chocolate.
CALCULATE FUNCTION
Q9. How many orders do we have for chocolate chips with over 500 orders?

You might also like