Dog Database SQL Statements

create database animals;
use animals;
create table dogs (name varchar(30), age int, weight double, vaccinated boolean);
insert into dogs values ('Tilly', 4, 20, true);
insert into dogs values ('Poppy', 1, 24, false);
insert into dogs values ('Zelda', 4, 35, true);
insert into dogs values ('Einstein', 10, 40, false);
insert into dogs values ('Snoopy', 3, 10, true);
select * from dogs;