Index: Ringtoets/Common/test/Ringtoets.Common.IO.Test/SoilProfile/SoilDatabaseQueryBuilderTest.cs
===================================================================
diff -u -rbe4427a66ef77dfa213048b0a823824ea679bce3 -r133fb73ed33467075fa1317ab736902755ff6e4f
--- Ringtoets/Common/test/Ringtoets.Common.IO.Test/SoilProfile/SoilDatabaseQueryBuilderTest.cs	(.../SoilDatabaseQueryBuilderTest.cs)	(revision be4427a66ef77dfa213048b0a823824ea679bce3)
+++ Ringtoets/Common/test/Ringtoets.Common.IO.Test/SoilProfile/SoilDatabaseQueryBuilderTest.cs	(.../SoilDatabaseQueryBuilderTest.cs)	(revision 133fb73ed33467075fa1317ab736902755ff6e4f)
@@ -57,6 +57,21 @@
         }
 
         [Test]
+        public void GetStochasticSoilModelOfMechanismCountQuery_ReturnsExpectedValues()
+        {
+            // Call
+            string query = SoilDatabaseQueryBuilder.GetStochasticSoilModelOfMechanismCountQuery();
+
+            // Assert
+            const string expectedQuery =
+                "SELECT COUNT() AS nrOfRows " +
+                "FROM StochasticSoilModel SSM " +
+                "INNER JOIN Segment S USING(SSM_ID) " +
+                "INNER JOIN Mechanism M USING(ME_ID);";
+            Assert.AreEqual(expectedQuery, query);
+        }
+
+        [Test]
         public void GetStochasticSoilProfileProbabilitiesDefinedQuery_ReturnsExpectedValues()
         {
             // Call