-- Requires the contents of file states.sql to be loaded first.
.read states.sql

-- Tables in states.sql:
--   states(state):       US States + DC - HI - AK
--   landlocked(state):   Table of landlocked (not adjacent to ocean) states
--   adjacencies(s1, s2): States that are adjacent to each other

select "States adjacent to California:";
select "REPLACE THIS LINE WITH YOUR SOLUTION";
-- Finds lengths of possible paths between two states
create table distances as
  with
    distance(start, end, hops) as (
    select "Your", "Code", "Here"
    )
  select * from distance;

select "Lengths of paths between CA and WI:";
select * from distances where start = "CA" and end = "WI" order by hops;

select "States 3 hops from CA:";
select "REPLACE THIS LINE WITH YOUR SOLUTION";
select "Long alphabetical paths:";
with
  paths(s, n, last) as (
    select "Your", "Code", "Here"
  )
select s from paths where n > 6 order by -n;
