SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

-- Create Students table
CREATE TABLE Students (
    StID INT PRIMARY KEY,
    Name VARCHAR(50)
);

-- Insert data into Students table
INSERT INTO Students (StID, Name) VALUES
(101, 'Mike'),
(102, 'Nancy'),
(103, 'Tom'),
(104, 'Lisa'),
(105, 'John'),
(106, 'Matt');

-- Create Hobbies table
CREATE TABLE Hobbies (
    StID INT,
    Hobby VARCHAR(50),
    PracticeDate DATE,
    FOREIGN KEY (StID) REFERENCES Students(StID)
);

-- Insert data into Hobbies table
INSERT INTO Hobbies (StID, Hobby, PracticeDate) VALUES
(101, 'Bikes', '2024-02-12'),
(101, 'Music', '2024-02-24'),
(101, 'Movies', '2024-03-14'),
(102, 'Art', '2024-02-13'),
(102, 'Music', '2024-02-23'),
(103, 'Soccer', '2024-03-21'),
(103, 'Drawing', '2024-04-04'),
(103, 'Movies', '2024-02-22'),
(105, 'Music', '2024-02-11'),
(105, 'Bikes', '2024-03-26');

-- Create Colours table
CREATE TABLE Colours (
    StID INT,
    Colour VARCHAR(50),
    PaintingDate DATE,
    FOREIGN KEY (StID) REFERENCES Students(StID)
);

-- Insert data into Colours table
INSERT INTO Colours (StID, Colour, PaintingDate) VALUES
(101, 'Blue', '2024-05-30'),
(101, 'Green', '2024-04-01'),
(102, 'Yellow', '2024-04-20'),
(102, 'Black', '2024-03-18'),
(102, 'Green', '2024-02-29'),
(103, 'Black', '2024-03-26'),
(103, 'Yellow', '2024-02-11'),
(103, 'Red', '2024-03-30'),
(104, 'Blue', '2024-02-07'),
(104, 'Pink', '2024-02-24');

26 rows affected

StID	Name	Hobby	PracticeDate	Colour	PaintingDate
101	Mike	Bikes	2024-02-12	Blue	2024-05-30
101	Mike	Movies	2024-03-14	Green	2024-04-01
101	Mike	Music	2024-02-24	null	null
102	Nancy	null	null	Yellow	2024-04-20
102	Nancy	Art	2024-02-13	Black	2024-03-18
102	Nancy	Music	2024-02-23	Green	2024-02-29
103	Tom	Drawing	2024-04-04	Black	2024-03-26
103	Tom	Movies	2024-02-22	Red	2024-03-30
103	Tom	Soccer	2024-03-21	Yellow	2024-02-11
104	Lisa	null	null	Blue	2024-02-07
104	Lisa	null	null	Pink	2024-02-24
105	John	Bikes	2024-03-26	null	null
105	John	Music	2024-02-11	null	null