Which head's name has the substring 'Ha'? List the id and name
select head_id, name from head where name like '%ha%'
Who is head id 1?
select name from head where head_id = 1
What is Tiger woods's born state
select born_state from head where name = "Tiger Woods"
what is Tiger woods's age
select age from head where name = "Tiger Woods"
who is the oldest head
select * from head order by age desc limit 1
how many heads from Alabama?
select count ( * ) from head where born_state = "Alabama"