There are many wolves in the zoo: black wolf, white wolf, lucky wolf, little wolf. They all have 'wolf' at the end of their name

Question

Print the ages of all the wolves.

SELECT ages from zoo
WHERE animal LIKE ___________

Ans :

By using Like Operator :

' % a' = it means search any value which is ending with a;

So here
Ans ::. '%wolf'

Answer 1

Hi,
Which question did u answer?

Answer 2

Select column_name from table_name
Where column_name like '%wolf';

AS is just used to rename a column at the time of displaying the result.

Select column_name AS new_name from table_name

Answer 3

Why are you posting a question if you already know the answer to it?

Answer 4

Sorry ! May be there is incomplete question, My bad. I'm uploading complete questions ..

Answer 5

'%wolf'