Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT(piv),COUNT(piv) AS kolikrat
- FROM
- (SELECT CEIL(SUM(pullitr + 0.6 * tretinka + 0.8 * ctyrka + 0.5 * ctvrtka)) AS piv
- FROM zaznamy
- WHERE uid=17 AND YEAR(datum)=2015
- GROUP BY datum
- ORDER BY piv) AS dotaz
- GROUP BY piv
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement