--TASK1
--1.1
select * from Player
--1.2
select EnemyTypeDesc, atkValue, defValue from EnemyType;
--1.3
select TileTypeDesc from Tiletype descending;
--1.4
select TileTypeDesc from Tiletype descending where combatDiff >= 5;
--1.5
select enemy.id, enemytype.EnemyTypeDesc from enemy inner join EnemyType on enemy.enemytypeid=enemytype.id where hp <= 50;
--1.6
select xcoord, ycoord, tiletype.movementDiff from tile inner join tiletype on tile.TileTypeid = tiletype.id;
--1.7
select objectName from object where Ownerid is not null;
--1.8
select count(*) from enemy;
--1.9
select count(*) from tile inner join tiletype on tile.TileTypeid = tiletype.id where TileTypeDesc = "Road";
--1.10
select sum(worth) from object inner join tile on tile.id = object.tileid inner join tiletype on tile.TileTypeid = tiletype.id where TileTypeDesc = "Forest";
--1.11
select count(EnemyTypeid), enemytype.EnemyTypeDesc from enemy inner join enemytype on enemytype.id = enemy.EnemyTypeid group by EnemyTypeDesc;
--1.12
select EnemyTypeDesc from enemytype inner join enemy on enemy.enemytypeid = enemytype.id group by EnemyTypeDesc having count(enemytype.id) >= 2;

--TASK2
--2.1
select xcoord, ycoord from tile inner join player on player.tileid = tile.id where tileid = player.tileid;
--2.2
select TileTypeDesc from tiletype inner join tile on tile.tiletypeid = tiletype.id inner join player on player.tileid = tile.id where tileid = player.tileid;
--2.3
select movementDiff from tiletype inner join tile on tile.tiletypeid = tiletype.id inner join player on player.tileid = tile.id where tileid = player.tileid;
--2.4
select objectName from object where ownerid is not null;
--2.5
select xcoord, ycoord from tile inner join Object on object.tileid = tile.id where tileid = object.tileid;
--2.6
select enemy.name from enemy inner join player on enemy.Tileid = player.Tileid;
--2.7
select avg(hp) from enemy;
--2.8
select count(*) from enemy inner join enemytype on enemytype.id = EnemyTypeid where EnemyTypeDesc = "dragon";