Table: orgel_database
Columns: year
opus
town
kind
manuals
stops

Question: What are the manuals with a kind of r, and an opus of 144?
SQL: SELECT "manuals" FROM orgel_database WHERE "kind" = 'r' AND "opus" = '144'

Question: What are the manuals with an opus of 147?
SQL: SELECT "manuals" FROM orgel_database WHERE "opus" = '147'

Question: What kind is in the year 1978 and a manual of ii/p?
SQL: SELECT "kind" FROM orgel_database WHERE "year" = '1978' AND "manuals" = 'ii/p'

Question: What manuals have the opus of 135?
SQL: SELECT "manuals" FROM orgel_database WHERE "opus" = '135'

Question: What year was it the town of Eugene?
SQL: SELECT "year" FROM orgel_database WHERE "town" = 'eugene'

Question: What town has 15 stops and a NB kind?
SQL: SELECT "town" FROM orgel_database WHERE "stops" = '15' AND "kind" = 'nb'