Andmebaaside neljas kodutöö
)
SELECT fibNum
FROM FibTable;
GO
Graaf-tabelid:
SELECT DISTINCT Person.Name, Post.Content
FROM Person, Posted, Post, Likes
WHERE MATCH(Person-(Likes)->Post)
SELECT Person1.Name, Post.Content, Comments.Comment, Person2.Name
FROM Person Person1, Post, Posted, Comments, Person Person2
WHERE MATCH(Person1-(Posted)->Post<-(comments)-Person2)
SELECT Person1.Name, Person2.name, Person3.name
FROM Person Person1, Follows, Person Person2, Follows follows2, Person Person3
WHERE MATCH(Person1-(Follows)->Person2-(Follows2)->Person3)
AND Person1.name = 'Mari'
SELECT Person1.Name, Person2.Name, Post.Content
FROM Person Person1, Likes, Post, Likes Likes2, Person Person2
WHERE MATCH(Person1-(Likes)->Post<-(Likes2)-Person2)
AND Person1.Name = 'Kevin' AND Person2.Name = 'Peeter'
annaabi.ee 
