Advertisement
Guest User

vysledky select

a guest
Apr 26th, 2019
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select sum("pondelok 11:50") as "pondelok 11:50", sum("stvrtok 11:50") as "stvrtok 11:50", sum("stvrtok 17:00") as "stvrtok 17:00", sum("cez skuskove") as "cez skuskove"
  2. from vysledky where volba in('vyhovuje', 'velmi vyhovuje')
  3. union
  4. select sum("pondelok 11:50") as "pondelok 11:50", sum("stvrtok 11:50") as "stvrtok 11:50", sum("stvrtok 17:00") as "stvrtok 17:00", sum("cez skuskove") as "cez skuskove"
  5. from vysledky where volba = 'nevyhovuje'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement