write 6 simple SQL queries for one single simple table

This is the table (there are no other tables): create table descriptors_1 ( descriptor varchar(50), english varchar(300), french varchar(300), PRIMARY KEY(descriptor) ) The 6 queries only work with this table and can bee seen in the API documentation in the pdf attached. In query number two the like search should be translated in a wildcard like this ' %keyword%' so with anything before and after. We use postgresql.