Sample Queries MediaLib Project

1A:

SELECT title.titleName, title.publishYear, title.entryDate,
category.categoryName, media.mediaName, publisher.publisherName,
contributor.firstName, contributor.lastName, role.roleName, contributor.nationality
FROM title, category, media, publisher, contributor, title_contributor, role
WHERE title.mediaID = media.mediaID
AND title.publisherID = publisher.publisherID
AND title.categoryID = category.categoryID
AND (title_contributor.contributorID = contributor.contributorID AND title_contributor.titleID = title.titleID)
AND role.titleContributorID = title_contributor.titleContributorID
ORDER BY titleName;

titleName   publishYear entryDate   categoryName    mediaName   publisherName   firstName   lastName    roleName    nationality
accumsan convallis, ante lectus convallis   1994    2021-08-09  non magna.  Duis dignissim tempor arcu. Vestibulum ut   Felis Adipiscing Ltd    Wheeler Tamara  netus et malesuada  Bhutan
accumsan convallis, ante lectus convallis   1994    2021-08-09  non magna.  Duis dignissim tempor arcu. Vestibulum ut   Felis Adipiscing Ltd    Wheeler Tamara  pede    Bhutan
adipiscing elit. Aliquam auctor, velit eget 1982    2020-11-06  vel, mauris. Integer    lorem tristique aliquet. Phasellus fermentum convallis ligula. Donec luctus aliquet Est Ltd Rosales Yoko    vitae purus Turkey
ante blandit viverra. Donec tempus, lorem fringilla ornare placerat,    1964    2020-10-25  Etiam ligula    Donec elementum, lorem ut   Molestie Arcu Sed Corporation   Marsh   Kennedy lacus, varius   Brazil
arcu vel    1999    2021-03-04  eget lacus. et malesuada fames  Fringilla Cursus Purus Incorporated Marsh   Magee   sagittis. Nullam vitae  Bolivia
condimentum. Donec at   1997    2020-07-24  lobortis quam a nec, diam. Duis mi enim, condimentum eget,  Ridiculus Mus Proin Institute   Trevino Kathleen    varius. Nam porttitor scelerisque neque.    Montenegro
condimentum. Donec at   1997    2020-07-24  lobortis quam a nec, diam. Duis mi enim, condimentum eget,  Ridiculus Mus Proin Institute   Trevino Kathleen    lorem ipsum sodales Montenegro
congue a, aliquet vel, vulputate eu,    2013    2021-06-30  egestas hendrerit   Etiam imperdiet dictum magna. Ut tincidunt orci quis lectus. Nullam Placerat Corporation    Sheppard    Leroy   lectus pede, ultrices a,    Namibia
consequat, lectus sit   1997    2021-06-11  Nullam suscipit, est    malesuada malesuada. Integer id magna et ipsum  Imperdiet Ltd   Alvarez Cheryl  eget tincidunt dui augue    Taiwan
consequat, lectus sit   1997    2021-06-11  Nullam suscipit, est    malesuada malesuada. Integer id magna et ipsum  Imperdiet Ltd   Alvarez Cheryl  massa. Quisque porttitor eros   Taiwan
cubilia Curae; Donec tincidunt. 2004    2021-11-15  non magna.  Vestibulum accumsan Risus Donec Industries  Coffey  Chandler    eget laoreet posuere, enim nisl Turkmenistan
cubilia Curae; Donec tincidunt. 2004    2021-11-15  non magna.  Vestibulum accumsan Risus Donec Industries  Coffey  Chandler    elementum, lorem ut aliquam Turkmenistan
cubilia Curae; Donec tincidunt. 2004    2021-11-15  non magna.  Vestibulum accumsan Risus Donec Industries  Bradshaw    Harriet dui quis accumsan convallis, ante   Portugal
Cum sociis natoque penatibus et magnis dis  1984    2020-03-23  congue, elit    lorem lorem, luctus Ultricies Industries    Tyler   Wayne   amet luctus Tajikistan
Cum sociis natoque penatibus et magnis dis  1984    2020-03-23  congue, elit    lorem lorem, luctus Ultricies Industries    Montoya Seth    laoreet posuere, enim   Canada
dolor, nonummy ac, feugiat non, 1997    2020-05-27  lobortis    sit In Tincidunt Associates Wiggins Hashim  non, hendrerit id, ante. Nunc   Malawi
dolor, nonummy ac, feugiat non, 1997    2020-05-27  lobortis    sit In Tincidunt Associates Wiggins Hashim  ipsum cursus    Malawi
dolor, nonummy ac, feugiat non, 1997    2020-05-27  lobortis    sit In Tincidunt Associates Swanson Aristotle   risus quis diam luctus lobortis.    Heard Island and Mcdonald Islands
elit, dictum eu, eleifend nec, malesuada ut,    1997    2020-06-21  dictum. tellus faucibus leo, in lobortis tellus Cum LLP Mcclure Julie   ultricies ligula. Nullam enim. Sed  Equatorial Guinea
elit, dictum eu, eleifend nec, malesuada ut,    1997    2020-06-21  dictum. tellus faucibus leo, in lobortis tellus Cum LLP Mcclure Julie   id nunc Equatorial Guinea
elit, dictum eu, eleifend nec, malesuada ut,    1997    2020-06-21  dictum. tellus faucibus leo, in lobortis tellus Cum LLP Mcclure Julie   Proin non massa Equatorial Guinea
est ac mattis semper, dui lectus rutrum urna,   1994    2020-11-28  semper, dui lectus  id, libero. Donec consectetuer mauris id sapien. Cras dolor Phasellus Vitae Associates  Shannon Ori id, blandit Saint Vincent and The Grenadines
eu erat semper rutrum. Fusce    2018    2020-07-13  dui. Fusce  metus   Enim Sit Amet Consulting    Blake   Oren    senectus et Congo (Brazzaville)
eu erat semper rutrum. Fusce    2018    2020-07-13  dui. Fusce  metus   Enim Sit Amet Consulting    Blake   Oren    cursus a,   Congo (Brazzaville)
eu erat semper rutrum. Fusce    2018    2020-07-13  dui. Fusce  metus   Enim Sit Amet Consulting    Blake   Oren    congue turpis.  Congo (Brazzaville)
eu erat semper rutrum. Fusce    2018    2020-07-13  dui. Fusce  metus   Enim Sit Amet Consulting    Mclaughlin  MacKenzie   dui, in sodales Bangladesh
eu erat semper rutrum. Fusce    2018    2020-07-13  dui. Fusce  metus   Enim Sit Amet Consulting    Mclaughlin  MacKenzie   egestas nunc sed libero.    Bangladesh
eu erat semper rutrum. Fusce    2018    2020-07-13  dui. Fusce  metus   Enim Sit Amet Consulting    Mclaughlin  MacKenzie   tempor diam dictum  Bangladesh
eu metus. In lorem. Donec elementum, lorem ut   2015    2020-07-05  Suspendisse non leo.    adipiscing lobortis risus. In mi pede, nonummy ut, molestie Ligula Nullam Enim PC   Ball    MacKensie   nec tempus  Malaysia
id, mollis nec, cursus a, enim. Suspendisse aliquet, sem    1952    2021-04-19  et, Integer vulputate, risus a ultricies adipiscing,    Ultricies Industries    Carter  Holly   massa. Vestibulum   Virgin Islands, United States
id, mollis nec, cursus a, enim. Suspendisse aliquet, sem    1952    2021-04-19  et, Integer vulputate, risus a ultricies adipiscing,    Ultricies Industries    Carter  Holly   Morbi   Virgin Islands, United States
in consectetuer ipsum nunc id   1989    2020-08-25  at  ac ipsum. Phasellus vitae   Ornare Placerat PC  Fowler  Sacha   egestas Virgin Islands, United States
inceptos hymenaeos. Mauris  1997    2020-07-09  lorem,  placerat, augue. Sed molestie. Sed id risus Ac Urna Ut Incorporated Preston Seth    eget, venenatis Kuwait
inceptos hymenaeos. Mauris  1997    2020-07-09  lorem,  placerat, augue. Sed molestie. Sed id risus Ac Urna Ut Incorporated Preston Seth    rhoncus. Proin nisl sem, consequat  Kuwait
inceptos hymenaeos. Mauris  1997    2020-07-09  lorem,  placerat, augue. Sed molestie. Sed id risus Ac Urna Ut Incorporated Preston Seth    placerat.   Kuwait
interdum enim non nisi. Aenean eget 1991    2021-02-12  Cras    lacinia orci, consectetuer euismod  Molestie Arcu Sed Corporation   Bonner  Garrett sed orci lobortis augue Holy See (Vatican City State)
interdum enim non nisi. Aenean eget 1991    2021-02-12  Cras    lacinia orci, consectetuer euismod  Molestie Arcu Sed Corporation   Bonner  Garrett eget, dictum placerat,  Holy See (Vatican City State)
interdum enim non nisi. Aenean eget 1991    2021-02-12  Cras    lacinia orci, consectetuer euismod  Molestie Arcu Sed Corporation   Riley   Ramona  Vivamus Korea, North
interdum enim non nisi. Aenean eget metus.  1993    2021-01-30  mattis  mauris erat eget ipsum. Suspendisse sagittis.   Tellus Nunc Associates  May Tanya   justo faucibus  French Southern Territories
interdum enim non nisi. Aenean eget metus.  1993    2021-01-30  mattis  mauris erat eget ipsum. Suspendisse sagittis.   Tellus Nunc Associates  May Tanya   Quisque porttitor eros  French Southern Territories
interdum enim non nisi. Aenean eget metus.  1993    2021-01-30  mattis  mauris erat eget ipsum. Suspendisse sagittis.   Tellus Nunc Associates  May Tanya   mi eleifend egestas.    French Southern Territories
interdum enim non nisi. Aenean eget metus.  1993    2021-01-30  mattis  mauris erat eget ipsum. Suspendisse sagittis.   Tellus Nunc Associates  Preston Seth    a, malesuada id, erat. Etiam    Kuwait
interdum feugiat. Sed nec metus facilisis lorem 1978    2021-07-12  consectetuer    arcu. Morbi Eget Ltd    Le  Quincy  ante, iaculis   Mozambique
ipsum nunc id enim. Curabitur massa. Vestibulum 1980    2019-12-11  leo, in lobortis    auctor, nunc nulla vulputate dui, nec tempus mauris erat    Vehicula Aliquet Libero Corporation Stanley Nina    sit amet diam   Mauritania
ipsum nunc id enim. Curabitur massa. Vestibulum 1980    2019-12-11  leo, in lobortis    auctor, nunc nulla vulputate dui, nec tempus mauris erat    Vehicula Aliquet Libero Corporation Wheeler Tamara  leo, in lobortis tellus justo   Bhutan
ipsum nunc id enim. Curabitur massa. Vestibulum 1980    2019-12-11  leo, in lobortis    auctor, nunc nulla vulputate dui, nec tempus mauris erat    Vehicula Aliquet Libero Corporation Wheeler Tamara  lectus. Cum sociis  Bhutan
lectus quis massa.  1957    2021-02-17  vel, mauris. Integer    lorem lorem, luctus Nascetur Ridiculus Institute    Woodward    Quinlan Donec   Cook Islands
lectus quis massa.  1957    2021-02-17  vel, mauris. Integer    lorem lorem, luctus Nascetur Ridiculus Institute    Bradshaw    Harriet Nunc mauris elit, dictum eu,    Portugal
lectus quis massa.  1957    2021-02-17  vel, mauris. Integer    lorem lorem, luctus Nascetur Ridiculus Institute    Bradshaw    Harriet mattis semper, dui lectus rutrum    Portugal
libero  1998    2021-01-28  fermentum   amet ante. Vivamus non lorem vitae odio sagittis semper.    Sit Amet Limited    Castaneda   Gloria  scelerisque,    Czech Republic
libero  1998    2021-01-28  fermentum   amet ante. Vivamus non lorem vitae odio sagittis semper.    Sit Amet Limited    Bradley Cara    Nunc quis arcu  Isle of Man
libero  1998    2021-01-28  fermentum   amet ante. Vivamus non lorem vitae odio sagittis semper.    Sit Amet Limited    Bradley Cara    nec quam. Curabitur vel lectus. Isle of Man
lobortis risus. In mi pede, nonummy ut, molestie in, tempus 2010    2021-08-12  Fusce fermentum nec, diam. Duis mi enim, condimentum eget, volutpat ornare, Proin Nisl Ltd  Mitchell    Wilma   et malesuada    Somalia
lobortis risus. In mi pede, nonummy ut, molestie in, tempus 2010    2021-08-12  Fusce fermentum nec, diam. Duis mi enim, condimentum eget, volutpat ornare, Proin Nisl Ltd  Mitchell    Wilma   mauris, rhoncus id, mollis nec, Somalia
lorem, vehicula 1990    2020-09-05  litora torquent Aliquam erat volutpat. Nulla facilisis. Suspendisse Placerat Corporation    Stein   Linda   lobortis. Class aptent taciti   Guinea-Bissau
lorem, vehicula 1990    2020-09-05  litora torquent Aliquam erat volutpat. Nulla facilisis. Suspendisse Placerat Corporation    Stein   Linda   sed leo. Cras vehicula  Guinea-Bissau
lorem, vehicula 1990    2020-09-05  litora torquent Aliquam erat volutpat. Nulla facilisis. Suspendisse Placerat Corporation    Bradshaw    Harriet fringilla   Portugal
mauris sapien, cursus in, hendrerit consectetuer, cursus et, magna. 2009    2020-02-20  mattis  imperdiet, erat Auctor Ltd  Swanson Aristotle   Duis    Heard Island and Mcdonald Islands
mauris sapien, cursus in, hendrerit consectetuer, cursus et, magna. 2009    2020-02-20  mattis  imperdiet, erat Auctor Ltd  Swanson Aristotle   sem mollis dui, in sodales  Heard Island and Mcdonald Islands
mauris sapien, cursus in, hendrerit consectetuer, cursus et, magna. 2009    2020-02-20  mattis  imperdiet, erat Auctor Ltd  Swanson Aristotle   Donec elementum, lorem ut   Heard Island and Mcdonald Islands
mi eleifend egestas. Sed    2014    2021-08-14  parturient  tincidunt. Donec vitae erat vel pede blandit congue. In scelerisque Suspendisse Inc.    Smith   Kasper  nunc    Brunei
mi eleifend egestas. Sed    2014    2021-08-14  parturient  tincidunt. Donec vitae erat vel pede blandit congue. In scelerisque Suspendisse Inc.    Smith   Kasper  Curabitur dictum. Phasellus in felis.   Brunei
mi tempor lorem, eget mollis lectus 1956    2020-06-17  consectetuer    ipsum leo elementum sem, vitae aliquam eros turpis non  Suspendisse Inc.    Mendez  Ingrid  convallis erat, eget    Nepal
Nullam scelerisque neque sed sem egestas blandit.   1982    2021-07-25  Pellentesque ultricies  vel, faucibus   Arcu Limited    Wiggins Hashim  libero at auctor ullamcorper,   Malawi
nunc id enim.   1955    2021-07-16  tristique ac, eleifend  mattis. Cras eget   Urna Nec Luctus Company Herman  Maris   in molestie tortor nibh Pitcairn Islands
nunc id enim.   1955    2021-07-16  tristique ac, eleifend  mattis. Cras eget   Urna Nec Luctus Company Herman  Maris   primis in   Pitcairn Islands
orci luctus et ultrices posuere cubilia Curae; Phasellus ornare.    2004    2021-06-29  arcu.   Donec elementum, lorem ut   Nascetur Ridiculus Institute    Mclaughlin  MacKenzie   sagittis felis. Bangladesh
orci luctus et ultrices posuere cubilia Curae; Phasellus ornare.    2004    2021-06-29  arcu.   Donec elementum, lorem ut   Nascetur Ridiculus Institute    Mclaughlin  MacKenzie   natoque penatibus et magnis Bangladesh
orci luctus et ultrices posuere cubilia Curae; Phasellus ornare.    2004    2021-06-29  arcu.   Donec elementum, lorem ut   Nascetur Ridiculus Institute    Bradshaw    Harriet et  Portugal
parturient montes, nascetur 1974    2020-08-28  Nunc ac Duis dignissim tempor arcu. Vestibulum ut   Donec Consectetuer Corporation  Wong    Wayne   a ultricies Guinea
pharetra. Quisque ac libero nec 2000    2020-01-13  lorem,  magna tellus faucibus   Nam Nulla Magna Ltd Preston Seth    Integer urna.   Kuwait
pharetra. Quisque ac libero nec 2000    2020-01-13  lorem,  magna tellus faucibus   Nam Nulla Magna Ltd Preston Seth    at, Kuwait
Phasellus in felis. Nulla tempor augue  2009    2020-08-11  non magna.  semper pretium neque. Morbi Ridiculus Mus Proin Institute   Montoya Seth    Curabitur dictum. Phasellus in felis.   Canada
placerat velit. Quisque varius. Nam porttitor   1972    2020-04-29  lectus justo eu mauris erat eget ipsum. Suspendisse sagittis.   A Ltd   Suarez  Anthony id, Western Sahara
posuere vulputate, lacus. Cras interdum. Nunc   1981    2020-05-02  vel, mauris. Integer    Nam consequat dolor vitae dolor. Donec fringilla. Donec feugiat Tellus Faucibus Consulting  Spears  Prescott    morbi tristique Iran
quis, pede. Praesent eu 2002    2020-04-23  vitae sodales nisi  arcu. Morbi Ligula Limited  Bradshaw    Harriet velit. Quisque  Portugal
risus quis diam luctus  1955    2020-04-17  mi. Aliquam Donec elementum, lorem ut   Lorem Foundation    Mckinney    Thor    nibh dolor, nonummy ac, Nicaragua
risus. Donec nibh enim, gravida sit amet, dapibus id, blandit   1959    2021-06-16  purus.  nec, diam. Duis mi enim, condimentum eget,  Ridiculus Mus Proin Consulting  Woodward    Jerry   cubilia Curae; Donec    Czech Republic
risus. Quisque libero lacus, varius et, euismod et, commodo 1955    2021-06-07  lorem,  ante dictum cursus. Nunc mauris elit, dictum eu, eleifend   Molestie Arcu Sed LLP   Bradley Erica   est New Zealand
risus. Quisque libero lacus, varius et, euismod et, commodo 1955    2021-06-07  lorem,  ante dictum cursus. Nunc mauris elit, dictum eu, eleifend   Molestie Arcu Sed LLP   Bradley Erica   bibendum. Donec felis   New Zealand
risus. Quisque libero lacus, varius et, euismod et, commodo 1955    2021-06-07  lorem,  ante dictum cursus. Nunc mauris elit, dictum eu, eleifend   Molestie Arcu Sed LLP   Bradley Erica   Sed New Zealand
rutrum eu, ultrices sit 1958    2020-07-13  eu turpis. Nulla    risus. Donec egestas. Aliquam   Sem Ut Dolor Incorporated   Washington  Quynn   lorem.  Cayman Islands
rutrum eu, ultrices sit 1958    2020-07-13  eu turpis. Nulla    risus. Donec egestas. Aliquam   Sem Ut Dolor Incorporated   Washington  Quynn   leo.    Cayman Islands
sagittis felis. 1998    2019-11-24  Proin non   tellus faucibus leo, in lobortis tellus Placerat Corporation    Williamson  Sybil   mollis. Congo, the Democratic Republic of the
sit 1991    2021-02-05  Cras    morbi tristique senectus et netus   Ornare Placerat PC  Williamson  Sybil   lectus quis massa. Mauris   Congo, the Democratic Republic of the
Suspendisse commodo tincidunt nibh. Phasellus nulla. Integer vulputate, 1953    2021-11-19  arcu.   augue, eu tempor erat   Eget Ltd    Woods   Kieran  urna. Ut    Mauritius
Suspendisse commodo tincidunt nibh. Phasellus nulla. Integer vulputate, 1953    2021-11-19  arcu.   augue, eu tempor erat   Eget Ltd    Blair   Rhea    sed Belarus
Suspendisse non leo. Vivamus nibh dolor, nonummy    1958    2021-03-11  lobortis    In lorem. Donec elementum, lorem ut Amet Ornare Associates  Kim Quintessa   primis in faucibus orci luctus  Syria
Suspendisse non leo. Vivamus nibh dolor, nonummy    1958    2021-03-11  lobortis    In lorem. Donec elementum, lorem ut Amet Ornare Associates  Mckinney    Thor    et malesuada fames  Nicaragua
tellus justo sit    2016    2020-06-21  gravida. Praesent   aliquet. Proin velit. Sed   Facilisis Facilisis Magna Company   Woodward    Quinlan tristique senectus  Cook Islands
tellus justo sit    2016    2020-06-21  gravida. Praesent   aliquet. Proin velit. Sed   Facilisis Facilisis Magna Company   Benton  Ethan   fringilla   Burundi
tellus justo sit    2016    2020-06-21  gravida. Praesent   aliquet. Proin velit. Sed   Facilisis Facilisis Magna Company   Salas   Adena   nec metus facilisis lorem   Guinea-Bissau
tellus justo sit    2016    2020-06-21  gravida. Praesent   aliquet. Proin velit. Sed   Facilisis Facilisis Magna Company   Salas   Adena   Curae;  Guinea-Bissau
tellus justo sit    2016    2020-06-21  gravida. Praesent   aliquet. Proin velit. Sed   Facilisis Facilisis Magna Company   Salas   Adena   non, vestibulum nec,    Guinea-Bissau
tristique pharetra. Quisque ac libero   2010    2019-11-25  tristique pharetra. augue, eu tempor erat   Urna Nec Luctus Company Nguyen  Kaitlin ullamcorper magna. Sed eu   South Sudan
vitae diam. Proin dolor. Nulla semper   1995    2020-01-28  orci, in consequat  Pellentesque    Ridiculus Mus Proin Institute   Wong    Alec    Suspendisse ac  Malawi
vitae diam. Proin dolor. Nulla semper   1995    2020-01-28  orci, in consequat  Pellentesque    Ridiculus Mus Proin Institute   Swanson Aristotle   magna. Duis dignissim tempor arcu.  Heard Island and Mcdonald Islands
vitae diam. Proin dolor. Nulla semper   1995    2020-01-28  orci, in consequat  Pellentesque    Ridiculus Mus Proin Institute   Swanson Aristotle   arcu eu Heard Island and Mcdonald Islands
vitae diam. Proin dolor. Nulla semper   1995    2020-01-28  orci, in consequat  Pellentesque    Ridiculus Mus Proin Institute   Spears  Prescott    Nam ligula  Iran
vitae diam. Proin dolor. Nulla semper   1995    2020-01-28  orci, in consequat  Pellentesque    Ridiculus Mus Proin Institute   Mayer   Audrey  gravida sagittis. Duis  Vanuatu

1B:

SELECT title.titleName, category.categoryName, media.mediaName
FROM title, category, media
WHERE title.mediaID = media.mediaID
AND title.categoryID = category.categoryID
AND (media.mediaName = "DVD" OR media.mediaName = "BluRay")

titleName   categoryName    mediaName

1C:

SELECT title.titleName, COUNT(media.mediaName = "DVD"),
COUNT(media.mediaName = "BluRay"), COUNT(media.mediaName = "Streaming")
FROM title, media, category
WHERE title.mediaID = media.mediaID
AND title.categoryID = category.categoryID
AND category.categoryName = "drama"

titleName   COUNT(media.mediaName = "DVD")  COUNT(media.mediaName = "BluRay")   COUNT(media.mediaName = "Streaming")
NULL    0   0   0

2A:

SELECT contributor.firstName, contributor.lastName, title.titleName, role.roleName
FROM title, contributor, role, title_contributor
WHERE title_contributor.titleID = title.titleID
AND title_contributor.contributorID = contributor.contributorID
AND role.titleContributorID = title_contributor.titleContributorID
AND contributor.firstName = "Tommy"
AND contributor.lastName = "Emmanuel"

firstName   lastName    titleName   roleName

2B:

SELECT contributor.firstName, contributor.lastName, title.titleName, role.roleName
FROM title, contributor, role, title_contributor
WHERE title_contributor.titleID = title.titleID
AND title_contributor.contributorID = contributor.contributorID
AND role.titleContributorID = title_contributor.titleContributorID
AND contributor.nationality = "Britain"

firstName   lastName    titleName   roleName

3A:

SELECT COUNT(category.categoryName = "Rock")
FROM title, category, media
WHERE title.categoryID = category.categoryID
AND title.mediaID = media.mediaID
AND (media.mediaName = "LP"
OR media.mediaName = "CD"
OR media.mediaName = "MP3"
OR media.mediaName = "FLAC")

COUNT(category.categoryName = "Rock")
0

4A:

SELECT COUNT(media.mediaName = "Kindle") AS "Kindle",
COUNT(media.mediaName = "CD") AS "CD",
COUNT(media.mediaName = "Audiobook") AS "Standard",
("Kindle" + "CD" + "Standard") AS "Total"
FROM title, media
WHERE title.mediaID = media.mediaID
AND (media.mediaName = "Kindle"
OR media.mediaName = "CD"
OR media.mediaName = "Audiobook")

Kindle  CD  Standard    Total
0   0   0   0