Guest User

Untitled

a guest
Jun 22nd, 2016
151
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.44 KB | None | 0 0
  1. 1.
  2. CREATE TABLE CONNEXION
  3. (
  4. NICK VARCHAR(25),
  5. URL VARCHAR(100),
  6. CON_D DATE,
  7. SEC INT
  8.     CONSTRAINT second_limit CHECK(LENGTH(SEC) >= 0 AND LENGTH(SEC) <= 100000)
  9. FOREIGN KEY (NICK) REFERENCES USER(NICK),
  10. FOREIGN KEY (URL) REFERENCES BLOG(URL)
  11. );
  12.  
  13. 2.
  14. ALTER TABLE BLOG
  15. ADD CREATION_D DATE;
  16.  
  17. 3.
  18. DELETE FROM CONNEXION
  19. WHERE CON_D BETWEEN '01.04.2014' AND '30.04.2014'
  20. AND SEC < 5;
  21.  
  22. 4.
  23. Nie rozumiem dokładnie polecenia
  24.  
  25. 5.
  26. SELECT (SELECT *
  27.     FROM USER)
  28. FROM USER, CONNEXION
  29. WHERE NICK.CONNEXION = USER.CONNEXION
  30. AND title = "University"
  31. ORDER BY USER.NAME DESC;
  32.  
  33. 6.
  34. SELECT AUTHOR
  35. FROM BLOG, CONNEXION
  36. WHERE BLOG.URL = CONNEXION.URL
  37. HAVING sec > (SELECT AVG(SEC)
  38.         FROM CONNEXION);
  39.  
  40. 7.
  41. SELECT (SELECT * FROM USER)
  42. FROM USER, BLOG, CONNEXION
  43. WHERE BLOG.URL = CONNEXION.URL
  44. AND USER.NICK = CONNEXION.NICK
  45. HAVING BLOG.LAST_UP = MAX(BLOG.LAST_UP)
  46.  
  47. 8.
  48. SELECT DISTINCT TOPIC, COUNT(CON_D) AS #CONNEXIONS
  49. FROM CONNEXION, BLOG
  50. HAVING BLOG.URL = CONNEXION.URL
  51. AND #CONNEXIONS > 3
  52. GROUP BY TOPIC;
  53.  
  54. 9.
  55. SELECT USER.NICK, USER.NAME, USER.SURNAME, USER.TELEF, USER.BIRTH, CON_D
  56. FROM USER, CONNEXION, BLOG
  57. WHERE BLOG.URL = CONNEXION.URL
  58. AND USER.NICK = CONNEXION.NICK
  59. AND CON_D > (SELECT DISTINCT TOPIC, CON_D, USER.NICK
  60.         FROM BLOG, CONNEXION);
  61.  
  62. 10.
  63. SELECT USER.NICK
  64. FROM USER, CONNEXION
  65. WHERE CONNEXION.NICK = USER.NICK
  66. AND SEC > 1000
  67. UNION
  68. SELECT USER.NICK
  69. FROM USER, CONNEXION
  70. WHERE CONNEXION.NICK = USER.NICK
  71. AND SEC > 1000;
Advertisement
Add Comment
Please, Sign In to add comment