title: how to solve this complicated sql query
body: <p>these are the five given tables
  <a href="http://i58.tinypic.com/53wcxe.jpg" rel="nofollow">http://i58.tinypic.com/53wcxe.jpg</a></p>
  
  <p>this is the recomanded result
  <a href="http://i58.tinypic.com/2vsrts7.jpg" rel="nofollow">http://i58.tinypic.com/2vsrts7.jpg</a></p>
  
  <p>please help how can i write a query to have this result.
  no idea how!!!!</p>
  
  <pre><code> SELECT K.*  , COUNT (A.Au_ID) AS AnzahlAuftr
   FROM Kunde K
   LEFT JOIN Auftrag A ON K.Kd_ID = A.Au_Kd_ID
   GROUP BY K.Kd_ID,K.Kd_Firma,K.Kd_Strasse,K.Kd_PLZ,K.Kd_Ort
   ORDER BY K.Kd_PLZ DESC;
  
   SELECT COUNT (F.F_ID) AS AnzahlFahrt
   FROM Fahrten F
   RIGHT JOIN Auftrag A ON A.Au_ID = F.F_Au_ID
  
  SELECT SUM (T.Ts_Strecke) AS SumStrecke
  FROM Teilstrecke T
  LEFT JOIN Fahrten F ON F.F_ID = T.Ts_F_ID
  </code></pre>
  
  <p>how to join these 3 in one?</p>