In the Ass1 database ...

* what are the tables?

\d ... 6 of them

* how many beers are there?

select count(*) from beers ..985

* are there any views? any functions?

\dv ... no views
\df ... no functions (except dbpop())

* what style of beer is Toohey's New?

select s.name
from   Styles s
       join Beers b on b.style = s.id
       join Brewed_by bb on bb.beer = b.id
       join Breweries y on bb.brewery = y.id
where  b.name = 'New' and y.name ilike '%toohey%'
;

* what is the longest beer name?

select name
from   Beers
where  length(name) = (select max(length(name)) from Beers)
;

* what is the most ridiculous beer name?

Can't determine ... don't have a measure for ridiculousness