I have thoroughly reviewed the Honorlock guidelines and ackn…

I have thoroughly reviewed the Honorlock guidelines and acknowledge each directive.  By proceeding with this assessment, I affirm my commitment to adhere to all Honorlock policies and directions for this assessment.  I understand that any violation of these guidelines will result in a zero for this assessment

Write the SQL query to provide information for this analysis…

Write the SQL query to provide information for this analysis: For customers who made purchases in April or May 2024, calculate how many days it has been since their last purchase (use Dec 31, 2024 as the reference date). This will help identify customers for re-engagement campaigns. (10 points) Display: customer_name, purchase_date, quarter#, days_since_purchase (sorted by purchase_date ascending)    

I have thoroughly reviewed the Honorlock guidelines and ackn…

I have thoroughly reviewed the Honorlock guidelines and acknowledge each directive.  By proceeding with this assessment, I affirm my committment to adhere to all Honorlock policies and directions for this assessment.  I understand that any violation of these guidelines will result in receiving a zero for this assessment. 

Write the SQL query to create a report showing region name,…

Write the SQL query to create a report showing region name, number of unique customers, total revenue from purchases, number of unique products purchased, and average purchase amount per region. This will guide regional marketing strategies. (10 points) Display: region_name, unique_customer_count, total_revenue, unique_products_purchased, avg_purchase_amount (sorted by total_revenue descending)  

Write a SQL query to provide information to help with the fo…

Write a SQL query to provide information to help with the following decision: the product team wants to understand Silver membership customers’ interest in Sports products. They want to identify all Silver members who have purchased products in the Sports category. Display: customer_name, city, product_name, purchase_amount, purchase_date (sorted by purchase_amount descending)