Persons id name address age eyeColor gender Likes id personA_id > Persons - personB_id → Persons -> Che semantics of the

Post by **answerhappygod** » Fri Apr 29, 2022 7:12 am

: Persons Id Name Address Age Eyecolor Gender Likes Id Persona Id Persons Personb Id Persons Che Semantics Of The 1 (41.66 KiB) Viewed 19 times

A. Write a query that returns the name of all persons that like
at least two people with green eyes. Eliminate duplicates from your
query result.
B. Write a query that returns the name of all male persons
that play soccer with a female player. Eliminate duplicates from
your result.

: Persons Id Name Address Age Eyecolor Gender Likes Id Persona Id Persons Personb Id Persons Che Semantics Of The 2 (106.49 KiB) Viewed 19 times

Persons id name address age eyeColor gender Likes id personA_id > Persons - personB_id → Persons -> Che semantics of the Likes table is that personA likes personB.
Persons id name address age eyeColor gender SportTogether personA_id id -> sport Persons personB_id - Persons he semantics of the Sport table is that persona does sport with persons Note that the table does not contain redundancies. The table may contain a row (id, sport, personA, personB) without containing the symmetric row (id, sport, personB, personA). Nevertheless, the relation is to be understood as symmetric: if persona does sport with persons , then of course personB also does sport with persona ! You need to take this into account in your query!