Description

---

The kingdom has been given terrible news: the King has passed away. While the nation is mourning, the noblemen need to decide who will take the throne next.

The late King had many children, and now it is necessary to determine their order of succession according to their seniority.

The list of the King’s children is represented as a table Successors with the following attributes:

• name: The child’s nam;
• birthday: The date of their birthday (it is guaranteed that birthday dates are unique);
• gender: Their gender (a character equal to 'M' or 'F').

The resulting table should contain the names of the King’s heirs in order of their succession to the throne as determined by their age, and preceded by their potential future titles (i.e. "King name" or "Queen name").

Example

For the following table Successors

name	birthday	gender
Amelia	1711-06-10	F
Anne	1709-11-02	F
Caroline	1713-06-10	F
Frederick	1707-02-01	M
Loisa	1724-12-18	F
Mary	1723-03-05	F
William	1721-04-26	M

the output should be

name
King Frederick
Queen Anne
Queen Amelia
Queen Caroline
King William
Queen Mary
Queen Loisa

• [execution time limit] 10 seconds (mysql)

1
2
3
4
5
6
7
/*Please add ; after each select statement*/
CREATE PROCEDURE orderOfSuccession()
BEGIN
	SELECT CONCAT(IF(gender='M','King ', 'Queen '), name) as name
    FROM Successors
    order by birthday;
END