singollo

kolos dla Kamileeek

Jan 27th, 2014
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.54 KB | None | 0 0
  1. SELECT
  2.   u.IDUslugi,
  3.   COUNT(hu.IDUslugi) * u.Cena AS wartoscHistorycznaUslugi,
  4.   COUNT(DISTINCT um.IDKlienta) AS iloscKlientow,
  5.   COUNT(DISTINCT um.IDOperatora) AS iloscOperatorow
  6. FROM Usluga u
  7. LEFT JOIN HistoriaUslug hu
  8.   ON hu.IDUslugi = u.IDUslugi
  9.     AND DATEDIFF(now(), hu.czasStart) > 5 * 365.25 /* 5 lat */
  10. LEFT JOIN Telefon t
  11.   ON hu.IDTelefonu = hu.IDTelefonu
  12. LEFT JOIN Umowa um
  13.   ON um.IDTelefonu = t.IDTelefonu
  14. GROUP BY u.IDUslugi
  15. HAVING
  16.   iloscKlientow >= 1000
  17.   AND iloscOperatorow >= 5
  18. ORDER BY wartoscHistorycznaUslugi
Advertisement
Add Comment
Please, Sign In to add comment