MySQL查询显示宠物没有接种过某种疫苗吗？

CREATE TABLE pet (
  id INT PRIMARY KEY,
  name VARCHAR(50),
  species VARCHAR(50),
  vaccine_status VARCHAR(50)
);

CREATE TABLE vaccine (
  id INT PRIMARY KEY,
  name VARCHAR(50)
);

INSERT INTO pet (id, name, species, vaccine_status) VALUES
(1, 'Tom', 'Cat', 'Vaccinated'),
(2, 'Jerry', 'Mouse', 'Not Vaccinated'),
(3, 'Spike', 'Dog', 'Vaccinated');

INSERT INTO vaccine (id, name) VALUES
(1, 'Rabies'),
(2, 'Distemper'),
(3, 'Parvovirus');

SELECT pet.name
FROM pet
LEFT JOIN vaccine ON pet.vaccine_status = vaccine.name
WHERE pet.vaccine_status <> 'Vaccinated' OR pet.vaccine_status IS NULL;