SELECT factory_id, factory_name, address
FROM food_factory
WHERE address LIKE '%강원도%'
ORDER BY factory_id ASC
SELECT flavor
FROM first_half
ORDER BY total_order DESC, shipment_id ASC
SELECT
member_id,
member_name,
gender,
date_format(date_of_birth, '%Y-%m-%d') AS date_of_birth
FROM member_profile
WHERE date_format(date_of_birth, '%m') = 3 AND gender = 'w' AND tlno IS NOT NULL
ORDER BY member_id ASC
SELECT fh.flavor
FROM first_half fh JOIN icecream_info ii
ON fh.flavor = ii.flavor
WHERE total_order > 3000 AND INGREDIENT_TYPE='fruit_based'
ORDER BY total_order DESC
SELECT pt_name, pt_no, gend_cd, age, IFNULL(tlno, 'NONE')
FROM patient
WHERE age <= 12 AND gend_cd = 'w'
ORDER BY age DESC, pt_name ASC
SELECT dr_name, dr_id, mcdp_cd, DATE_FORMAT(hire_ymd, '%Y-%m-%d')
FROM doctor
WHERE mcdp_cd IN('CS', 'GS')
ORDER BY hire_ymd DESC, dr_name ASC
SELECT user_id, product_id
from online_sale
group by user_id, product_id
having count(user_id)>1
order by user_id asc, product_id desc
SELECT * from animal_ins
SELECT name, datetime from animal_ins order by animal_id desc
SELECT animal_id, name from animal_ins where intake_condition = "Sick"
SELECT animal_id, name from animal_ins where intake_condition != "Aged"
SELECT name
from animal_ins
where datetime = (select min(datetime) from animal_ins)
SELECT animal_id, name, datetime
from animal_ins
order by name asc, datetime desc
SELECT animal_id, name from animal_ins