7 kyu

SQL with LOTR: Elven Wildcards

9,686 of 9,688sHale

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.

Fundamentals
SQL
Databases
Data Science

Stats:

CreatedApr 19, 2018
PublishedApr 19, 2018
Warriors Trained14436
Total Skips1028
Total Code Submissions43665
Total Times Completed9688
SQL Completions9686
Total Stars102
% of votes with a positive feedback rating92% of 1126
Total "Very Satisfied" Votes972
Total "Somewhat Satisfied" Votes134
Total "Not Satisfied" Votes20
Total Rank Assessments8
Average Assessed Rank
7 kyu
Highest Assessed Rank
7 kyu
Lowest Assessed Rank
8 kyu
Ad
Contributors
  • sHale Avatar
  • Voile Avatar
Ad