Find all the properties that Ewe is defined for (e.g., this would NOT return agreement between the definite article and the noun,since Ewe has no definite articles)

[THIS LAST SENTENCE IS A TYPO, IT SHOULD READ “SINCE EWE HAS NO 
GENDER”]

 select property from property, language
 where property.id = language.propertyid
 and language.language = "Ewe";

+---------------------------------------------------+
| property                                          |
+---------------------------------------------------+
| Weak object pronouns follow finite verb           |
| Definite article precedes noun                    |
| Presence of double negation for clausal negation. |
| Presence of Yes-No Question particle.             |
| Finite verb precedes subject in Yes-No Questions. |
| Presence of declarative complementizer.           |
| Auxiliary selection..                             |
+---------------------------------------------------+

Find all the example sentences listed for Ewe

select value from example
where type = "words"
and language = "Ewe";

+----------------------------------+
| value                            |
+----------------------------------+
| Kofi, kpO-E                      |
| Ntsu, la, me, va, hade, o        |
| Kofi, me, kpO, Ama, o            |
| e, Du, nu, a                     |
| Kofi, gblO, be, Ama, le, ha, dzi |
+----------------------------------+

[FOR THE ABOVE, WE WANT THE SENTENCES TO BE RETURNED AS
GLOSSED SENTENCES. THE FIRST LINE IS AS ABOVE (WITHOUT
COMMAS) THE SECOND LINE IS THE GLOSS (ENGLISH WORDS) AND
THE THIRD LINE IS THE TRANSLATION. THE PROBLEM WITH THE VALUES
AS ABOVE IS THAT NOT EVERYBODY KNOWS EWE, AND SO CANNOT USE
THE DATA. SO WHAT NEEDS TO BE RETURNED ARE THE INTERLINEAR GLOSSES
(THE THREE LINE FORMAT I JUST DESCRIBED].

Find all the properties with values for Ewe.

select property.property from property, language
where property.id = language.propertyid
and language.language = "Ewe"
and language.value = "yes";

+---------------------------------------------------+
| property                                          |
+---------------------------------------------------+
| Weak object pronouns follow finite verb           |
| Presence of double negation for clausal negation. |
| Presence of Yes-No Question particle.             |
| Presence of declarative complementizer.           |
+---------------------------------------------------+

[I DON’T THIS IS QUITE RIGHT. THIS LIST IS THE SET OF PROPERTIES
THAT HAVE A “YES” VALUE FOR EWE. BUT THE QUERY IS FOR ANY PROPERTY
FOR WHICH EWE HAS SOME VALUE, IN OUR CURRENT PROTOTYPE THESE
VALUES WOULD BE “YES” OR “NO”. SO ACTUALLY THIS QUERY IS IDENTICAL
TO THE FIRST QUERY. IN OTHER WORDS, WHAT I WROTE INITIALLY IS REDUNDANT. THE FOLLOWING TWO QUERIES ARE IDENTICAL:

Find all the properties that Ewe is defined for
(e.g., this would NOT return agreement
between the definite article and the noun,
since Ewe has no definite articles)

Find all the properties with values for Ewe.]

Find all the properties with values with accompanying example sentences for Ewe.(this is in effect, "Give a summary of Ewe")

select property.property, example.type, example.value
from property, example
where property.id = example.sentenceProperty
and example.language = "Ewe";

[THE FOLLOWING HAS THE RIGHT INFORMATION, BUT IT IS DIFFICULT TO FOLLOW. WHAT SHOULD BE DISPLAYED IS:

WEAK OBJECT PRONOUNS FOLLOW FINITE VERB: YES (FOR EWE)

KOFI KPO-E
KOFI SEE-3SG
“KOFI SEES HIM/HER/IT”]

IN OTHER WORDS, EACH PROPERTY WILL BE ACCOMPANIED BY
ITS VALUE AND THE EXAMPLES WHICH ILLUSTRATE THE PROPERTY.
THE EXAMPLES WILL ALWAYS BE IN THE ABOVE THREE LINE FORMAT. 
NOTE THAT THE FIRST AND THE SECOND LINE ARE ALIGNED.]

+---------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+
| property                                          | type        | value                        |
+---------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+
| Weak object pronouns follow finite verb           | comment     | Capital 'O'and capital 'E' stand for symbols in Ewe that require a specific font to produced in a word processor. |
| Weak object pronouns follow finite verb           | translation | Kofi saw him/her/it.                        |
| Weak object pronouns follow finite verb           | words       | Kofi, kpO-E                        |
| Weak object pronouns follow finite verb           | gloss       | Kofi, see.past-3sg                        |
| Definite article precedes noun                    | gloss       | Def, professor, sing.pres.3sg                        |
| Definite article precedes noun                    | words       | Ntsu, la, me, va, hade, o                        |
| Definite article precedes noun                    | translation | The man has not yet come.                        |
| Presence of double negation for clausal negation. | translation | Kofi didn't see Ama.                        |
| Presence of double negation for clausal negation. | words       | Kofi, me, kpO, Ama, o                        |
| Presence of double negation for clausal negation. | gloss       | Kofi, Neg1,see.past, Ama, Neg2                        |
| Presence of Yes-No Question particle.             | gloss       | 2sg, eat.past, thing, Q                        |
| Presence of Yes-No Question particle.             | translation | Did you eat?                        |
| Presence of Yes-No Question particle.             | words       | e, Du, nu, a                        |
| Presence of declarative complementizer.           | translation | Kofi said that Ama is singing.                        |
| Presence of declarative complementizer.           | words       | Kofi, gblO,be, Ama, le, ha, dzi                        |
| Presence of declarative complementizer.           | gloss       | Kofi, say.past, Compl, Ama, Prog, song, sing.prog                        |
+---------------------------------------------------+-------------+-----------------------------------------------------------------------------------------------------------+

Find all the properties that are defined for both Ewe and French.

select property from property
where id in
(select l1.propertyid from language as l1, language as l2
where l1.language = "ewe"
and l2.language = "french"
and l1.propertyid = l2.propertyid);

+---------------------------------------------------+
| property                                          |
+---------------------------------------------------+
| Weak object pronouns follow finite verb           |
| Definite article precedes noun                    |
| Presence of double negation for clausal negation. |
| Presence of Yes-No Question particle.             |
| Finite verb precedes subject in Yes-No Questions. |
| Presence of declarative complementizer.           |
| Auxiliary selection..                             |
+---------------------------------------------------+

Find all the properties that are defined for both Ewe and French for which Ewe and French have the same values.

select property from property
where id in
(
select l1.propertyid from language as l1, language as l2
where l1.language = "ewe"
and l2.language = "french"
and l1.propertyid = l2.propertyid
and l1.value = l2.value);

+---------------------------------------------------+
| property                                          |
+---------------------------------------------------+
| Presence of double negation for clausal negation. |
| Presence of declarative complementizer.           |
+---------------------------------------------------+