Advertisement
Guest User

Untitled

a guest
Apr 19th, 2015
183
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.98 KB | None | 0 0
  1. INSERT INTO ForgeRock
  2. ([productName], [description],grade)
  3. VALUES
  4. ('OpenIDM', 'Platform for building enterprise provisioning solutions',10),
  5. ('OpenAM', 'Full-featured access management',20),
  6. ('OpenDJ', 'Robust LDAP server for Java',30),
  7. ('OpenDJ', 'Robust LDAP server for Java',40),
  8. ('OpenDJ', 'Robust LDAP server for Java',50),
  9. ('OpenDJ', 'Robust LDAP server for Java',60),
  10. ('OpenDJ', 'Robust LDAP server for Java',70);
  11.  
  12. 1 90-100
  13.  
  14. 3 80-90
  15.  
  16. 2 70-80
  17.  
  18. .
  19. .
  20. .
  21.  
  22. 3 10-20
  23.  
  24. 3 0-10
  25.  
  26. SELECT * FROM
  27. (SELECT
  28. count(productName) studenttotal,grade
  29. FROM ForgeRock
  30. WHERE grade >= 90
  31. GROUP BY grade
  32. UNION ALL
  33. SELECT
  34. count(productName) studenttotal,grade
  35. FROM ForgeRock
  36. WHERE grade < 90 AND grade >= 80
  37. GROUP BY grade
  38. UNION ALL
  39. SELECT
  40. count(productName) studenttotal,grade
  41. FROM ForgeRock
  42. WHERE grade < 80 AND grade >= 70
  43. GROUP BY grade) a
  44. ORDER BY grade;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement