Advanced SQL Query Challenges with Solutions
Database Schema
CREATE TABLE learners(
learner_id VARCHAR(10),
full_name VARCHAR(10),
birth_date DATETIME,
gender VARCHAR(10)
);
INSERT INTO learners VALUES
('01', 'Zhao Lei', '1990-01-01', 'Male'),
('02', 'Qian Dian', '1990-12-21', 'Male'),
('03', 'Sun Feng', '1990-05-20', 'Male'),
('04', 'Li Yun', '1990-08-06', 'Male'),
('0 ...
Posted on Sat, 26 Sep 2026 16:52:42 +0000 by erupt