data_yep

[문제]  [MySQL]SELECT product_idFROM ProductsWHERE low_fats = 'Y' AND recyclable = 'Y'

[문제]  [MySQL]SELECT event_day AS 'day' , emp_id , SUM(out_time - in_time) AS total_timeFROM EmployeesGROUP BY event_day, emp_id

[문제]  [MySQL]WITH report_employee AS ( SELECT reports_to , COUNT(DISTINCT employee_id) AS reports_count , ROUND(AVG(age), 0) AS average_age FROM Employees GROUP BY reports_to HAVING reports_to IS NOT NULL)SELECT e.employee_id , e.name , re.reports_count , re.average_ageFROM Employees AS e LEFT JOIN report_employee AS re ON e.employee_id = re.reports_toWHE..

[문제]  [MySQL]SELECT user_id , COUNT(DISTINCT follower_id) AS followers_countFROM FollowersGROUP BY user_id

[문제]  [MySQL]WITH Unique_leads AS ( SELECT date_id , make_name , COUNT(DISTINCT lead_id) AS unique_leads FROM DailySales GROUP BY date_id, make_name) , Unique_partners AS ( SELECT date_id , make_name , COUNT(DISTINCT partner_id) AS unique_partners FROM DailySales GROUP BY date_id, make_name)SELECT ul.* , up.unique_partnersFROM Unique_leads AS ul ..

[문제]  [MySQL]SELECT tweet_idFROM TweetsWHERE LENGTH(content) > 15

[문제]  [MySQL]SELECT user_id , CONCAT(UPPER(SUBSTR(name, 1, 1)), LOWER(SUBSTR(name, 2))) AS nameFROM UsersORDER BY user_id ASC

[문제]  [MySQL]SELECT sa.machine_id , ROUND(AVG(ea.timestamp - sa.timestamp), 3) AS processing_timeFROM Activity AS sa JOIN Activity AS ea ON sa.machine_id = ea.machine_id AND sa.process_id = ea.process_id AND sa.activity_type = 'start' AND ea.activity_type = 'end'GROUP BY sa.machine_id

[문제]  [MySQL]WITH Users_cnt AS (SELECT * , COUNT(*) OVER () AS user_cnt FROM Users)SELECT r.contest_id , ROUND(COUNT(DISTINCT r.user_id) / u.user_cnt *100 , 2) AS percentageFROM Register AS r LEFT JOIN Users_cnt AS u ON r.user_id = u.user_idGROUP BY r.contest_idORDER BY percentage DESC, contest_id ASC

[문제]  [MySQL]SELECT u.name , SUM(amount) AS balanceFROM Users AS u LEFT JOIN Transactions AS t ON u.account = t.accountGROUP BY u.accountHAVING SUM(amount) > 10000