Conflict in metabase (what should I do )

1

SELECT count() AS count
FROM (SELECT bookings.user_id AS user_id, count() AS count FROM bookings
LEFT JOIN users Users ON bookings.user_id = Users.id
GROUP BY bookings.user_id
ORDER BY bookings.user_id ASC) source
WHERE source.count = 1

If I added a variable {{ }} it will not be working because of aliases
and if i remove aliases I get error (Every derived table must have its own alias)

2

Hi @Mohammad_Abdallah
There's a problem with your query, which is unrelated to Metabase, so first make sure that your query is valid and working. You'll likely find better help in a forum specific to your database type or on stackoverflow.com