Since their formation in 1981, Psychic TV has released over one hundred recordings, which feature an ever-changing line up of musicians. These recordings have been released on over twenty record labels, and are presented in a varitey of formats. This database will allow the user to explore the many incarnations of Psychic TV more effectively.

QUERIES

QUERY: Show all TITLES and corresponding RELEASE YEARS in chronological order

An INNER JOIN / Example of a ONE-TO-MANY RELATIONSHIP

QUERY: Show all YEARS in which NO RECORDINGS were released

An OUTER JOIN / Use of IF STATEMENT

QUERY: Show all TITLES and corresponding LABELS, RELEASE YEARS, FORMATs, and RECORDING TYPES in alphabetical order

A JOIN that includes 6 TABLES / Example of a MANY-TO-MANY RELATIONSHIP / Use of IF STATEMENT

QUERY: Show all LIVE RELEASES in LP format released between 1981-1989 on a record label starting with the letter T.

Complex WHERE clause filtering

QUERY: Show all Psychic TV MUSICIANS and the # of RECORDINGS they appear on

Aggregate function using COUNT and GROUP BY