Learn sql multiple tables 7 / 10 - cross join

[byteace47302]

Can anyone please post the solution to this “cross join” section?

[thepitycoder]

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.

[bethmoede]

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

[thepitycoder]

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?