PASTEBIN |  #1 paste tool since 2002 create new paste tools api archive faq PASTEBIN create new paste trending pastes sign up login my alerts my settings my profile Want more features on Pastebin? Sign Up , it's FREE! Public Pastes Monk Guide - Fatal 1 sec ago Untitled 2 sec ago Untitled 6 sec ago Untitled 17 sec ago Untitled 8 sec ago Untitled 10 sec ago Untitled 11 sec ago Untitled 12 sec ago By: a guest on Dec 15th, 2014 |  syntax: None |  size: 0.42 KB  |  views: 6 |  expires: Never download | raw | embed | report abuse | print Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac) SELECT rel.relations AS relations, res.sailor_ssn AS s_ssn, COUNT(*) AS totalreservations FROM reservations res JOIN (SELECT r1.sailorssn AS from, r2.sailorssn AS to, COUNT(*) AS relations FR...