Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 1.
- CREATE TABLE CONNEXION
- (
- NICK VARCHAR(25),
- URL VARCHAR(100),
- CON_D DATE,
- SEC INT
- CONSTRAINT second_limit CHECK(LENGTH(SEC) >= 0 AND LENGTH(SEC) <= 100000)
- FOREIGN KEY (NICK) REFERENCES USER(NICK),
- FOREIGN KEY (URL) REFERENCES BLOG(URL)
- );
- 2.
- ALTER TABLE BLOG
- ADD CREATION_D DATE;
- 3.
- DELETE FROM CONNEXION
- WHERE CON_D BETWEEN '01.04.2014' AND '30.04.2014'
- AND SEC < 5;
- 4.
- Nie rozumiem dokładnie polecenia
- 5.
- SELECT (SELECT *
- FROM USER)
- FROM USER, CONNEXION
- WHERE NICK.CONNEXION = USER.CONNEXION
- AND title = "University"
- ORDER BY USER.NAME DESC;
- 6.
- SELECT AUTHOR
- FROM BLOG, CONNEXION
- WHERE BLOG.URL = CONNEXION.URL
- HAVING sec > (SELECT AVG(SEC)
- FROM CONNEXION);
- 7.
- SELECT (SELECT * FROM USER)
- FROM USER, BLOG, CONNEXION
- WHERE BLOG.URL = CONNEXION.URL
- AND USER.NICK = CONNEXION.NICK
- HAVING BLOG.LAST_UP = MAX(BLOG.LAST_UP)
- 8.
- SELECT DISTINCT TOPIC, COUNT(CON_D) AS #CONNEXIONS
- FROM CONNEXION, BLOG
- HAVING BLOG.URL = CONNEXION.URL
- AND #CONNEXIONS > 3
- GROUP BY TOPIC;
- 9.
- SELECT USER.NICK, USER.NAME, USER.SURNAME, USER.TELEF, USER.BIRTH, CON_D
- FROM USER, CONNEXION, BLOG
- WHERE BLOG.URL = CONNEXION.URL
- AND USER.NICK = CONNEXION.NICK
- AND CON_D > (SELECT DISTINCT TOPIC, CON_D, USER.NICK
- FROM BLOG, CONNEXION);
- 10.
- SELECT USER.NICK
- FROM USER, CONNEXION
- WHERE CONNEXION.NICK = USER.NICK
- AND SEC > 1000
- UNION
- SELECT USER.NICK
- FROM USER, CONNEXION
- WHERE CONNEXION.NICK = USER.NICK
- AND SEC > 1000;
Advertisement
Add Comment
Please, Sign In to add comment