7 kyu

Easy SQL: ASCII Converter

6,385 of 6,387PG1

Description:

Given a demographics table in the following format:

** demographics table schema **

  • id
  • name
  • birthday
  • race

you need to return the same table where all text fields (name & race) are changed to the ascii code of their first byte.

e.g. Verlie = 86 Warren = 87 Horace = 72 Tracy = 84

Fundamentals
Strings
SQL

Stats:

CreatedJun 19, 2017
PublishedJun 19, 2017
Warriors Trained10657
Total Skips1596
Total Code Submissions14272
Total Times Completed6387
SQL Completions6385
Total Stars30
% of votes with a positive feedback rating86% of 733
Total "Very Satisfied" Votes559
Total "Somewhat Satisfied" Votes149
Total "Not Satisfied" Votes25
Total Rank Assessments28
Average Assessed Rank
7 kyu
Highest Assessed Rank
6 kyu
Lowest Assessed Rank
8 kyu
Ad
Contributors
  • PG1 Avatar
  • smile67 Avatar
Ad