Can anyone please post the solution to this “cross join” section?
Rather than posting the solution, if you post your attempt at solving it you might find that someone will help you understand where your solution is wrong and fix it.
COUNT (*) AS subscribers
CROSS JOIN online
WHERE start_month = month
AND end_month = month
GROUP BY subscribers;
wjondering where I went wrong
Hi, sorry for the delay in replying to you.
Taking a quick look at your SQL, it looks like you’re asking for two columns of data to be returned from your query:
COUNT(*) AS subscribers.
If we re-write your
SELECT as a single line:
SELECT month COUNT(*) AS subscribers
can you see what is missing?
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.