Question

How do I put this kind of question into an sqldeveloper (How many country names do not start with an 'A' or an 'E' letter?)

Answer 1

Answer:

select * from country where name not like 'A%' and loginid not like 'E%'

Explanation:

The percent sign acts as a wildcard, but it only works in conjunction with the 'like' construct.

Answer 2

Answer:

In short names, there is Cyprus, Comoros, DRC, Morocco, Djibouti, Burundi, Togo, Congo, Fiji, and Kosovo. However if we use only official names, there is only one country on the whole planet that has no A's and E's, and that country is the Kingdom of Morocco.

Explanation:

hope it helps