Hi, I have the following T-SQL problems I need help with.
Problem 1
Given the table Orders with columns OrderID, CustID, OrderDate, and OrderAmount,
Find all customers who have placed a first order between 1/1/2012 and 12/31/2012 and who have a total order of at least $300 since 1/1/2013.
Problem 2
Given the table Orders with columns OrderID, CustID, OrderDate, and OrderAmount,
Determine what percentage of customers placing their first order between 1/1/2012 and 12/31/2012 also placed a second additional order during the same year. Return a table with the count of total first year customers, and the number of those same customers who have ordered more than once in their first year, and the calculated percentage of first year customers who have multiple orders in that year.
Problem 1
Given the table Orders with columns OrderID, CustID, OrderDate, and OrderAmount,
Find all customers who have placed a first order between 1/1/2012 and 12/31/2012 and who have a total order of at least $300 since 1/1/2013.
Problem 2
Given the table Orders with columns OrderID, CustID, OrderDate, and OrderAmount,
Determine what percentage of customers placing their first order between 1/1/2012 and 12/31/2012 also placed a second additional order during the same year. Return a table with the count of total first year customers, and the number of those same customers who have ordered more than once in their first year, and the calculated percentage of first year customers who have multiple orders in that year.
