@izharaazmi @alikon
Please test

I have tested this item ✅ successfully on 2a2fbd0

Teststack:
MAMP 4.2 on macOS 10.1.2
PostgreSQL 9.6.4 on Docker

Tested:

• Log in as administrator
• Menus -> Manage (Without patch, this action is not possible due to sql error)

Without patch:
Error page with title "Error: 0 ERROR: column "m.language" must appear in the GROUP BY clause or be used in an aggregate function LINE 1: ...E(SUM(m.home), 0) WHEN 0 THEN '' WHEN 1 THEN CASE m.language... ^"

With patch:
All menus are displayed as expected.

Tested @icampus

Please also test the following condition:

Go to #__menu table and set two or more record in a menutype to home=1 manually. Then check if the globe icon is displayed in the admin menu for that menu type.

@izharaazmi Could you specify further what I need to do, to test your scenario? I manually set some lines to home=1, but I don't know where and when I should see that globe icon.

I've set two records to home=1 in the #__menu table, and the globe icon is well displayed.
Just log in to administrator, and click on "Menus".

I have tested this item ✅ successfully on f3dc52a

When testing Joomla 3.7.5 with PostgreSQL, Administrator page displays noting but the error description: "Error page with title "Error: 0 ERROR: column "m.language" must appear in the GROUP BY clause or be used in an aggregate function LINE 1"
After applying the patch it worked as expected and all menus were displayed correctly.
@icampus

@SamuelSchepp can you please retest?

I have tested this item ✅ successfully on f3dc52a

Still works with patch as described earlier. @icampus

RTC after two successful tests.

@twister65 Last 2 commits are in wrong branch - this should by a separate PR.