Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- u.IDUslugi,
- COUNT(hu.IDUslugi) * u.Cena AS wartoscHistorycznaUslugi,
- COUNT(DISTINCT um.IDKlienta) AS iloscKlientow,
- COUNT(DISTINCT um.IDOperatora) AS iloscOperatorow
- FROM Usluga u
- LEFT JOIN HistoriaUslug hu
- ON hu.IDUslugi = u.IDUslugi
- AND DATEDIFF(now(), hu.czasStart) > 5 * 365.25 /* 5 lat */
- LEFT JOIN Telefon t
- ON hu.IDTelefonu = hu.IDTelefonu
- LEFT JOIN Umowa um
- ON um.IDTelefonu = t.IDTelefonu
- GROUP BY u.IDUslugi
- HAVING
- iloscKlientow >= 1000
- AND iloscOperatorow >= 5
- ORDER BY wartoscHistorycznaUslugi
Advertisement
Add Comment
Please, Sign In to add comment