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.
1 Like
SELECT month
COUNT (*) AS subscribers
FROM newspaper
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: month
, and COUNT(*) AS subscribers
.
If we re-write your SELECT
as a single line:
SELECT month COUNT(*) AS subscribers
can you see what is missing?
1 Like
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.