diff --git a/internal/postgres/path_test.go b/internal/postgres/path_test.go
index 9d80fe2..fa308d9 100644
--- a/internal/postgres/path_test.go
+++ b/internal/postgres/path_test.go
@@ -35,6 +35,10 @@
 		{"m.com", "v2.0.0+incompatible", "a", false},
 		{"m.com/a", "v1.1.0", "b", false},
 		{"m.com/b", "v2.0.0+incompatible", "a", true},
+		{"cloud.google.com/go", "v0.69.0", "pubsublite", false},
+		{"cloud.google.com/go/pubsublite", "v0.4.0", "", false},
+		{"cloud.google.com/go", "v0.74.0", "compute/metadata", false},
+		{"cloud.google.com/go/compute/metadata", "v0.0.0-20181115181204-d50f0e9b2506", "", false},
 	} {
 		m := sample.Module(testModule.module, testModule.version, testModule.packageSuffix)
 		if err := testDB.InsertModule(ctx, m); err != nil {
@@ -165,6 +169,26 @@
 				IsRedistributable: true,
 			},
 		},
+		{
+			name: "prefer pubsublite nested module",
+			path: "cloud.google.com/go/pubsublite",
+			want: &internal.UnitMeta{
+				ModulePath:        "cloud.google.com/go/pubsublite",
+				Name:              "pubsublite",
+				Version:           "v0.4.0",
+				IsRedistributable: true,
+			},
+		},
+		{
+			name: "prefer compute metadata in main module",
+			path: "cloud.google.com/go/compute/metadata",
+			want: &internal.UnitMeta{
+				ModulePath:        "cloud.google.com/go",
+				Name:              "metadata",
+				Version:           "v0.74.0",
+				IsRedistributable: true,
+			},
+		},
 	} {
 		t.Run(test.name, func(t *testing.T) {
 			if test.module == "" {
diff --git a/internal/postgres/unit.go b/internal/postgres/unit.go
index 18e64c9..b432fc6 100644
--- a/internal/postgres/unit.go
+++ b/internal/postgres/unit.go
@@ -111,8 +111,8 @@
 			WHEN m.version_type = 'prerelease' THEN 4
 			ELSE 5
 		END`,
-		"m.sort_version DESC",
 		"m.module_path DESC",
+		"m.sort_version DESC",
 	).PlaceholderFormat(squirrel.Dollar)
 }