Answered step by step
Verified Expert Solution
Question
1 Approved Answer
syntax Error WITH total _ customers AS ( SELECT COUNT ( DISTINCT customerID ) AS total FROM JVS _ Schema.Customer ) , returning _
syntax Error
WITH totalcustomers AS
SELECT COUNTDISTINCT customerID AS total
FROM JVSSchema".Customer
returningcustomers AS
SELECT COUNTDISTINCT CcustomerID AS Returning
FROM JVSSchema".Customer AS C
JOIN JVSSchema".Rental AS R ON RCustomerIDCCustomerID
JOIN JVSSchema".Order AS O ON ROrderIDOOrderID
GROUP BY CcustomerID HAVING COUNTOOrderID
SELECT Creturning Ctotal AS retentionrate
FROM returningcustomers AS Return, totalcustomers AS total;
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started