Morzanne

SELECT team.name, COUNT(wizard.id) AS total FROM player
JOIN wizard ON player.wizard_id = wizard.id
JOIN team ON player.team_id=team.id
GROUP BY team.name
ORDER BY COUNT(wizard.id) DESC;


SELECT team.name FROM player
JOIN team ON player.team_id=team.id
GROUP BY team.name

Morzanne

SELECT wizard.firstname, wizard.lastname, player.role, team.name FROM player
INNER JOIN team ON team.id = player.team_id
INNER JOIN wizard ON wizard.id = player.wizard_id
ORDER BY team.name, player.role, wizard.lastname, wizard.firstname;

SELECT wizard.firstname, wizard.lastname FROM player
INNER JOIN wizard ON wizard.id = player.wizard_id
WHERE player.role = 'seeker'
ORDER BY wizard.lastname, wizard.firstname;

Morzanne

public class Classroom{
  
  public static void main(String[] args){
    
    Wilder Aurelien = new Wilder("Aurelien", false);
    
    System.out.println(Aurelien.whoAmI());
    System.out.println("Je m'apelle "+Aurelien.getFirstName()+" et je suis aware: "+Aurelien.isAware());

    

Morzanne

import java.util.Arrays;

public class Movies{
  
  public static void main(String[] args){
    String[] movies = {"Indiana Jones and the Temple of Doom","Raiders of the Lost Ark","Indiana Jones and the Last Crusade" };
    String[][] actors = {{"Harrison Ford","Kate Capshaw","Jonathan Ke Quan"},{"Harrison Ford","Karen Allen","Paul Freeman"},{"Harrison Ford","Sean Connery","River Phoenix"}};
    for (int i = 0; i < movies.length; i++){
      System.out.println("In the movie: "+movies[i]+",the main actors are: "+Arrays.toString(actors[i])); 
      

Morzanne

public class  Decipherer {
  
  public static String automatisation(String code){
    
    int longueur = code.length() / 2;
    String substr = code.substring(5,(longueur+5));
    String replace = substr.replace("@#?"," ");
    String reverse = new StringBuilder(replace).reverse().toString();
    return reverse;

Morzanne

import java.util.Arrays;

public class Movies{
  
  public static void main(String[] args){
    String[] movies = {"Indiana Jones and the Temple of Doom","Raiders of the Lost Ark","Indiana Jones and the Last Crusade" };
    String[][] actors = {{"Harrison Ford","Kate Capshaw","Jonathan Ke Quan"},{"Harrison Ford","Karen Allen","Paul Freeman"},{"Harrison Ford","Sean Connery","River Phoenix"}};
    for (int i = 0; i < movies.length; i++){
      System.out.println("In the movie: "+movies[i]+",the main actors are: "+Arrays.toString(actors[0+1])); 
      

Morzanne

public class LastCrusade{
  
  public static void main(String[] args) {
    
	String movieName = "Indiana Jones and the Last Crusade";
    boolean haveSeenMovie = true;
    int date = 1989;
    float imdbScore = 8.2f;
    
    System.out.println(movieName+"\n"+haveSeenMovie+"\n"+date+"\n"+imdbScore);

Morzanne

public class CandyCount{
  
  public static void main(String[] args) {
    
    float money = 12.4f;
    float price = 1.2f;
    int candies = 0;
    
    if(money>0 && price >0){

Morzanne

public class Senpai{
  
  public static void main(String[] args) {
    
    System.out.println("Notice me Senpai");
    
  }
  
  
}

Morzanne

https://image.noelshack.com/fichiers/2019/18/1/1556535651-capture-du-2019-04-29-12-59-27.png

https://image.noelshack.com/fichiers/2019/18/1/1556535658-capture-du-2019-04-29-13-00-24.png