@hadifarnoud Try using the UI to create a simple question and then go to the Notebook editor to convert it to a query:
https://www.metabase.com/docs/latest/users-guide/custom-questions.html#viewing-the-sql-that-powers-your-question
@hadifarnoud Try using the UI to create a simple question and then go to the Notebook editor to convert it to a query:
https://www.metabase.com/docs/latest/users-guide/custom-questions.html#viewing-the-sql-that-powers-your-question