Resolved: I am getting an error when submitting the 2 codes in the exercise
2 answers ( 2 marked as helpful)
Please, execute the following command:
set @@global.sql_mode := replace(@@global.sql_mode, 'ONLY_FULL_GROUP_BY', '');
Then, you have to restart the Workbench in order to save the new settings.
Copied.
Hi Fatma!
Thanks for reaching out.
Please, use the code provided by Muhammad. Then, you have to restart the Workbench in order to save the new settings.
Hope this helps.
Best,
Tsvetelin