What is a spontaneous process/entropy?

In bygone times I used to be
A dreamer who would hurl
On every side an insolence
Of emerald and pearl;
But now that I am kneeling
At the feet of the Supreme
I have ceased to be the dreamer
And have learned to be the dream.

(1) What did the poet dream of in his bygone days ?
(2) What is the latest realisation of the poet ?

Pranay, who is an Indian, created a table named “Friends” to store his friend’s detail. Table “Friends” is shown below. Write commands in SQL for (i) to (iv) and output for (v) to (vii).

(i) To display list of all foreigner friends.

(ii) To list name, city and country in descending order of age.

(iii) To count how many friends have email id on gmail.

(iv) To list name and city of those friends who don’t have an email id.

(v) Select name, country from friends where age>12 and name like ‘A%’;

(vi) Select ucase(concat(name,” * “,city)) from friends where country like ‘Denmark’;

(vii) Select mid(name,1,4) as “UID” from friends where country like ‘USA’;