Question: SQL Query error SELECT COUNT ( DISTINCT C . customerID ) AS Total _ customers FROM ( SELECT COUNT ( DISTINCT C . customerID )
SQL Query error
SELECT COUNTDISTINCT CcustomerID AS Totalcustomers
FROM
SELECT COUNTDISTINCT CcustomerID AS returningcustomers
FROM JVSSchema".Customer AS C
JOIN JVSSchema".Rental AS R ON RCustomerIDCCustomerID
JOIN JVSSchema".Order AS O ON ROrderIDOOrderID
GROUP BY CcustomerID HAVING COUNTOOrderID
AS SUBQUERY
SELECT returningcustomers totalcustomers AS retentionrate;
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
