The 'Error executing view: Memory usage restrictions prevent the execution of the query' occurs when the executing query consumes more memory than the configured memory limit.
To resolve this, I would open the Memory Usage tab by navigating to Administration > Server Configuration dialog for increasing the value of “Maximum query size (MB)” parameter and execute the view again.
I would refer to the section [Configuring the Memory Usage and Swapping Policy](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/server_administration_-_configuring_the_server/configuring_the_memory_usage_and_swapping_policy/configuring_the_memory_usage_and_swapping_policy#configuring-the-memory-usage-and-swapping-policy) of Virtual DataPort Administration guide for more information on configuring memory usage.
You can also refer to the community Q&A which answers the similar issue: [Get rows with a minimum value from a column](https://community.denodo.com/answers/question/details?questionId=9060g000000XeEsAAK&title=Get+rows+with+a+minimum+value+from+a+column)
Hope this helps!