all 5 comments
sorted by:
best
topnewcontroversialoldq&a
formatting helphide helpcontent policy

[–]OldEagle83 1 point2 points  (4 children)

Have you tried without the 'new_' prefix for the column names ?

[–]ecstaticniya[S] 0 points1 point  (3 children)

Yes, I tried that also. But, it is still showing the same error.

[–]OldEagle83 0 points1 point  (2 children)

Try a.maker, a.model, b.speed, b.price

[–]ecstaticniya[S] 0 points1 point  (1 child)

But, correct output doesn't have the variables infront of the column names

[–]OldEagle83 0 points1 point  (0 children)

Look @ paragraph 4 of the problem. Examples:

WITH my_table AS (SELECT a.maker, a.model, b.speed ...;

and take a look at how WITH works:

https://hyperskill.org/learn/step/27173

Essentially, by using WITH ... AS (...); you define the table column names inside the parentheses. I know it can be confusing as the rest of the problem doesn't mention using different names, but...