stephanieokoh
stephanieokoh stephanieokoh
  • 26-02-2021
  • Computers and Technology
contestada

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?)

Respuesta :

cjclaveria
cjclaveria cjclaveria
  • 26-02-2021

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

Answer Link
tonb
tonb tonb
  • 26-02-2021

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 Link

Otras preguntas

the dutch in new Netherland prospered by
Maya spent 40% of her savings on a bike it cost her $85 how much money does she have left
To walk fearfully? I need a few words that mean that.
Lymphocytes produce special proteins against foreign invaders called _____. a. macrophages b. antigens c. antibodies d. lymph
Seasonal changes occur because of A. Earth’s tilt. B. Earth’s shape. C. the distance between Earth and the moon. D. the time of year.
Which invention was most important in revolutionizing the meat industry?
Find the area of the figure. Assume the figure is made up of triangles. A. 98 cm² B. 147 cm² C. 196 cm² D. 294 cm²
why was 1492 a turning point in history
System of glands that regulate metabolism reproduction and other functions
Matthew drove 8/16 of the way to Kentucky and Fred drove the other 1/2 distance of the distance who drove the most