다시

-- MySQL select animal_type, count(animal_id) as count from animal_ins where animal_type IN('Cat', 'Dog') group by animal_type order by animal_type asc; -- Oracle SELECT ANIMAL_TYPE, COUNT(ANIMAL_TYPE) AS "count" FROM ANIMAL_INS GROUP BY ANIMAL_TYPE ORDER BY ANIMAL_TYPE;

-- MySQL select NAME, count(NAME) as 'COUNT' from animal_ins group by NAME having count(NAME) > 1 order by name asc; -- Oracle SELECT NAME, COUNT(NAME) AS "COUNT" FROM ANIMAL_INS WHERE NAME IS NOT NULL GROUP BY NAME HAVING COUNT(NAME) > 1 ORDER BY NAME ASC;

-- MySQL select hour(DATETIME) as HOUR, count(DATETIME) as COUNT from ANIMAL_OUTS where hour(DATETIME) between 9 and 19 group by hour(DATETIME) order by hour(DATETIME) -- Oracle SELECT TO_CHAR(DATETIME, 'HH24') AS "HOUR", COUNT(*) AS "COUNT" FROM ANIMAL_OUTS WHERE TO_CHAR(DATETIME, 'HH24') BETWEEN 09 AND 19 GROUP BY TO_CHAR(DATETIME, 'HH24') ORDER BY TO_CHAR(DATETIME, 'HH24');

-- MySQL SET @hour := -1; select (@hour := @hour +1) AS HOUR, (select count(*) from animal_outs where hour(datetime) = @hour) as COUNT from animal_outs where @hour