Also, what is their customer ID? | Weeks's id? | yes, Weeks' ID, please.
SELECT  custid  FROM accounts where name  =  "Weeks"
customer ID refers to custid; name = 'Weeks' implies filtering records where the name column matches 'Weeks';