USE SPRINGFIELD; /* SELECT SQRT(9); SELECT SQRT(2.7); SELECT SQRT(-9); SELECT POW(3,2), POWER(3,2); SELECT ABS(5) ABS1, ABS(-5) ABS2, ABS(0) ABS3, ABS(-5.3) ABS4, ABS(-5*3) ABS5; SELECT SIGN(5) SIGN1, SIGN(-5) SIGN2, SIGN(0) SIGN3; SELECT SUM(TOTAL_MASCOTAS) TOTAL_MASCOTAS FROM (SELECT FAM.DESC_FAMILIA, COUNT(*) TOTAL_MASCOTAS FROM MASCOTAS MAS INNER JOIN FAMILIAS FAM ON MAS.ID_FAMILIA=FAM.ID_FAMILIA GROUP BY FAM.DESC_FAMILIA) A; SELECT MAX(TOTAL_MASCOTAS) TOTAL_MASCOTAS FROM (SELECT FAM.DESC_FAMILIA, COUNT(*) TOTAL_MASCOTAS FROM MASCOTAS MAS INNER JOIN FAMILIAS FAM ON MAS.ID_FAMILIA=FAM.ID_FAMILIA GROUP BY FAM.DESC_FAMILIA) A; SELECT SUM(TOTAL_MASCOTAS) MAX_TOTAL_MASCOTAS FROM (SELECT FAM.DESC_FAMILIA, COUNT(*) TOTAL_MASCOTAS FROM MASCOTAS MAS INNER JOIN FAMILIAS FAM ON MAS.ID_FAMILIA=FAM.ID_FAMILIA GROUP BY FAM.DESC_FAMILIA) A; SELECT MIN(TOTAL_MASCOTAS) MIN_TOTAL_MASCOTAS FROM (SELECT FAM.DESC_FAMILIA, COUNT(*) TOTAL_MASCOTAS FROM MASCOTAS MAS INNER JOIN FAMILIAS FAM ON MAS.ID_FAMILIA=FAM.ID_FAMILIA GROUP BY FAM.DESC_FAMILIA) A; CREATE VIEW VW_MASCOTAS AS SELECT FAM.DESC_FAMILIA, COUNT(*) TOTAL_MASCOTAS FROM MASCOTAS MAS INNER JOIN FAMILIAS FAM ON MAS.ID_FAMILIA=FAM.ID_FAMILIA GROUP BY FAM.DESC_FAMILIA; */ SELECT SUM(TOTAL_MASCOTAS) TOTAL_MASCOTAS FROM VW_MASCOTAS; SELECT MAX(TOTAL_MASCOTAS) MAX_TOTAL_MASCOTAS FROM VW_MASCOTAS; SELECT MIN(TOTAL_MASCOTAS) MAX_TOTAL_MASCOTAS FROM VW_MASCOTAS; SELECT AVG(TOTAL_MASCOTAS) MEDIA_TOTAL_MASCOTAS FROM VW_MASCOTAS; SELECT 6 DIV 2; SELECT 7 DIV 2; SELECT 9 DIV -3; SELECT 6 MOD 2; SELECT 7 MOD 2; SELECT 9 MOD -3; SELECT 8 MOD -3; SELECT ROUND(1234.56389), ROUND(1234.56389,0), ROUND(-1234.56789); SELECT ROUND(1234.56389,2), ROUND(1234.56389,-2); SELECT TRUNCATE(1234.56389,0), TRUNCATE(-1234.56389,2), TRUNCATE(1234.56389,-2); SELECT CEIL(42.65), CEIL(42.1), CEIL(-42.65), CEIL(-42.1), CEILING(42.65), CEILING(42.1), CEILING(-42.65), CEILING(-42.1); SELECT FLOOR(42.65), FLOOR(42.1), FLOOR(-42.65), FLOOR(-42.1); SELECT RAND(); SELECT ID_PERSONAJE, GREATEST(ID_FAMILIA, ID_SEXO, ID_MATRIMONIO, ID_LUGAR_RESIDENCIA, ID_PROFESION, ID_LUGAR_PROFESION) ID_MAYOR FROM PERSONAJES; SELECT ID_PERSONAJE, GREATEST(IFNULL(ID_FAMILIA,0), IFNULL(ID_SEXO,0), IFNULL(ID_MATRIMONIO,0), IFNULL(ID_LUGAR_RESIDENCIA,0), IFNULL(ID_PROFESION,0), IFNULL(ID_LUGAR_PROFESION,0)) ID_MAYOR FROM PERSONAJES; SELECT ID_PERSONAJE, LEAST(IFNULL(ID_FAMILIA,0), IFNULL(ID_SEXO,0), IFNULL(ID_MATRIMONIO,0), IFNULL(ID_LUGAR_RESIDENCIA,0), IFNULL(ID_PROFESION,0), IFNULL(ID_LUGAR_PROFESION,0)) ID_MENOR FROM PERSONAJES; SELECT EXP(1), EXP(0), EXP(2), EXP(-2); SELECT LN(1), LN(0), LN(2), LN(2.7), LN(-1); SELECT LOG10(1), LOG10(0), LOG10(2), LOG10(2.7), LOG10(-1), LOG10(100); SELECT LOG2(1), LOG2(0), LOG2(2), LOG2(2.7), LOG2(-1), LOG2(100); SELECT LOG(2,1), LOG(2,0), LOG(2,2), LOG(2,2.7), LOG(2,-1), LOG(2,100); SELECT LOG(7,1), LOG(7,0), LOG(7,2), LOG(7,2.7), LOG(7,-1), LOG(7,100); SELECT RADIANS(0), RADIANS(45), RADIANS(90), RADIANS(180), RADIANS(270), RADIANS(360); SELECT DEGREES(PI()), DEGREES(2.5), DEGREES(-0.8), DEGREES(PI()*2); SELECT PI(), PI()*3, PI()*1.000000000000000000000000000000; SELECT SIN(0), SIN(90), SIN(PI()/2), SIN(-90); SELECT COS(0), COS(90), COS(PI()), COS(-90); SELECT COT(3), COT(-1), COT(5.3); SELECT ASIN(0.65), ASIN(3), ASIN(1), ASIN(-1); SELECT ACOS(0.65), ACOS(3), ACOS(1), ACOS(-1); SELECT ATAN(0.65), ATAN(3), ATAN(1), ATAN(-1);