Mode:
Duration:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
CREATE TABLE rooms (
room_id SERIAL PRIMARY KEY,
room_number VARCHAR(10),
room_type VARCHAR(50),
price_per_night DECIMAL(10,2)
);
CREATE TABLE guests (
guest_id SERIAL PRIMARY KEY,
guest_name VARCHAR(100)
);
CREATE TABLE reservations (
reservation_id SERIAL PRIMARY KEY,
guest_id INTEGER REFERENCES guests(guest_id),
room_id INTEGER REFERENCES rooms(room_id),
check_in DATE,
check_out DATE
);
INSERT INTO rooms (room_number, room_type, price_per_night) VALUES
('101', 'Single', 120),
('201', 'Suite', 300);
INSERT INTO guests (guest_name) VALUES
('Alice Johnson'),
('Mark Wilson');
INSERT INTO reservations (guest_id, room_id, check_in, check_out) VALUES
(1, 1, '2025-04-01', '2025-04-05'),
(2, 2, '2025-04-10', '2025-04-15');
SELECT
g.guest_name,
r.room_number,
res.check_in,
res.check_out
FROM reservations res
JOIN guests g
ON g.guest_id = res.guest_id
JOIN rooms r
ON r.room_id = res.room_id;Coding works best on desktop or with an external keyboard.