SQL with LOTR: Elven Wildcards
Description:
Deep within the fair realm of Lothlórien, you have been asked to create a shortlist of candidates for a recently vacated position on the council.
Of so many worthy elves, who to choose for such a lofty position? After much thought you decide to select candidates by name, which are often closely aligned to an elf's skill and temperament.
Choose those with tegil appearing anywhere in their first name, as they are likely to be good calligraphers, OR those with astar anywhere in their last name, who will be faithful to the role.
Elves table:
- firstname
- lastname
all names are in lowercase
To aid the scribes, return the firstname and lastname column concatenated, separated by a space, into a single shortlist column, and capitalise the first letter of each name.
Similar Kata:
Stats:
Created | Apr 19, 2018 |
Published | Apr 19, 2018 |
Warriors Trained | 14436 |
Total Skips | 1028 |
Total Code Submissions | 43665 |
Total Times Completed | 9688 |
SQL Completions | 9686 |
Total Stars | 102 |
% of votes with a positive feedback rating | 92% of 1126 |
Total "Very Satisfied" Votes | 972 |
Total "Somewhat Satisfied" Votes | 134 |
Total "Not Satisfied" Votes | 20 |
Total Rank Assessments | 8 |
Average Assessed Rank | 7 kyu |
Highest Assessed Rank | 7 kyu |
Lowest Assessed Rank | 8 kyu |