Bug Report for https://neetcode.io/problems/sql-inner-join
Please describe the bug below and include any steps to reproduce the bug or screenshots if possible.
It is not really a bug, but maybe a misunderstanding or a mistake in the example given before the challenge. The code is : SELECT *
FROM users
INNER JOIN orders ON users.user_id = orders.user_id;
However both tables (orders and users) have a user_id column. In the output only one column user_id is shown, even though the code does not precise anything that would allow only orders.user_id or users.user_id.
Bug Report for https://neetcode.io/problems/sql-inner-join
Please describe the bug below and include any steps to reproduce the bug or screenshots if possible.
It is not really a bug, but maybe a misunderstanding or a mistake in the example given before the challenge. The code is : SELECT *
FROM users
INNER JOIN orders ON users.user_id = orders.user_id;
However both tables (orders and users) have a user_id column. In the output only one column user_id is shown, even though the code does not precise anything that would allow only orders.user_id or users.user_id.