-- Suggested testing environment: -- https://www.db-fiddle.com/ with MySQL version set to 8 -- Example case create statement: CREATE TABLE questions ( id INTEGER NOT NULL PRIMARY KEY, name VARCHAR(50) NOT NULL, childId INTEGER, FOREIGN KEY (childId) REFERENCES questions(id) ); INSERT INTO questions (id, name, childId) VALUES (3, 'SQL select v3', NULL), (2, 'C# tuples', NULL), (1, 'SQL select v2', 3), (0, 'SQL select', 1); DELIMITER // CREATE PROCEDURE findLatestVersion( IN questionId INTEGER ) BEGIN -- Write your code here END; // DELIMITER ; -- Example case: CALL findLatestVersion(0) -- Expected output (in any order): -- 3