Mostrar Cuotas asignadas a un tipo de prestamo, MySQL

Language: Layout:

#MySQL 5.7.12
#please drop objects you've created at the end of the script 
#or check for their existance before creating
#'\\' is a delimiter

DROP TABLE IF EXISTS detalle_cuotas;
    DROP TABLE IF EXISTS cantidad;

CREATE TABLE  IF NOT EXISTS cantidad 
        (
          id          INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
          monto_dolares      VARCHAR(50) NOT NULL,
          numero_cuotas INT NOT NULL
        );
       
        CREATE TABLE  IF NOT EXISTS detalle_cuotas 
        (
          id          INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
          cantidad_id   INT NOT NULL,
          monto_dolares VARCHAR(50) NOT NULL
        );

INSERT INTO cantidad (monto_dolares, numero_cuotas) 
        VALUES  
                ('1000',5),
                ('2000',2),
                ('1000',4);

INSERT INTO detalle_cuotas (cantidad_id, monto_dolares) 
                VALUES  
                (1,'1000'),
                (1,'1000'),
                (1,'1000'),
                (1,'1200'),
                (1,'1200'),
                (2,'2000'),
                (2,'2000'),
                (3,'1000'),
                (3,'1000'),
                (3,'1000'),
                (3,'1200');        
    
        SELECT * from cantidad;
        SELECT * from detalle_cuotas;
        
        select * from detalle_cuotas where cantidad_id = '3';


absolute service time: 0,36 sec