Sample Task SQL

task.sql

#Task 1
ALTER TABLE mapping
  ADD CONSTRAINT mapping_fk_1 FOREIGN KEY (user_id) REFERENCES users (id),
  ADD CONSTRAINT mapping_fk_2 FOREIGN KEY (program_id) REFERENCES programs (id);

#Task 2
Select u.name as 'User', p.name as 'Program' from users u 
INNER JOIN mapping m ON u.id = m.user_id 
INNER JOIN programs p on m.program_id = p.id;

#Task 3 
Select u.name as 'User', p.name as 'Program' from users u 
INNER JOIN mapping m ON u.id = m.user_id 
INNER JOIN programs p on m.program_id = p.id 
WHERE m.dated > DATE_SUB(NOW(), INTERVAL 10 MINUTE);