travcunn/ufc-database

UFC database personal project

ufc-database

UFC database

Queries

List all people defeated by (person name)

select person2.name from fight join person as person1 on fight.fighterA = person1.id join person as person2 on fight.fighterB = person2.id where person1.name = "Conor McGregor";

List all people defeated by (person name)

select person1.name from fight join person as person1 on fight.fighterA = person1.id join person as person2 on fight.fighterB = person2.id where person2.name = "Conor McGregor";

List all people defeated by (person name) in UFC fights

select person2.name from fight join person as person1 on fight.fighterA = person1.id join person as person2 on fight.fighterB = person2.id where person1.name = "Conor McGregor" and fight.name like "UFC%";