Question Versions
An application for testing programmers contains an initial question version and newer question versions, represented by the following schema:
TABLE questions
id INTEGER NOT NULL PRIMARY KEY
name VARCHAR(50) NOT NULL
childId INTEGER
FOREIGN KEY (childId) REFERENCES questions(id)The latest question version has childId set to NULL, other question versions will have childId set to the next version. Each question version can be a child of only one other question version.
Finish the findLatestVersion stored procedure so that it returns the latest question version.
See the example case for more details.
To move focus out of the code editor press ESC and then TAB.
Database Engine: MySQL
Tags
- AI-resistant
- MySQL
- Select
- Stored Procedure
Information
Score Distribution
Not enough data for chart.Would you like to see our other questions?
We have 1000+ premium hand-crafted questions for 160+ job skills and 20+ coding languages. We prefer questions with small samples of actual work over academic problems or brain teasers.
On the blog
Since we're all biased and we use incorrect proxies, why not just outsource hiring to experts or recruitment agencies? After all, they've been screening people for many years, so they must know how to do it right?
Not really. I was surprised to discover that many experts...
