data_yep

[문제]  [MySQL]SELECT v.customer_id , COUNT(*) AS count_no_transFROM Visits AS v LEFT JOIN Transactions AS t ON v.visit_id = t.visit_idWHERE t.transaction_id IS NULLGROUP BY v.customer_id

[문제]  [MySQL]SELECT *FROM PatientsWHERE conditions LIKE 'DIAB1%' OR conditions LIKE '% DIAB1%'

[문제]  [MySQL]SELECT *FROM UsersWHERE mail REGEXP '^[a-zA-Z][a-zA-Z0-9_.-]*@leetcode[.]com$'

[문제]  [MySQL]SELECT sell_date , COUNT(DISTINCT product) AS num_sold , GROUP_CONCAT(DISTINCT product ORDER BY product ASC) AS productsFROM ActivitiesGROUP BY sell_date

[문제]  [MySQL]SELECT u.name , IFNULL(SUM(r.distance), 0) AS travelled_distanceFROM Users AS u LEFT JOIN Rides AS r ON u.id = r.user_idGROUP BY u.idORDER BY travelled_distance DESC, name ASC

[문제]  [MySQL]SELECT stock_name , SUM(CASE WHEN operation = 'Buy' THEN price * (-1) WHEN operation = 'Sell' THEN price END) AS capital_gain_lossFROM StocksGROUP BY stock_name

[문제]  [MySQL]SELECT eu.unique_id , e.nameFROM Employees AS e LEFT JOIN EmployeeUNI AS eu ON e.id = eu.id

[문제]  [MySQL]WITH Rating AS ( SELECT m.* , u.* , mr.rating , mr.created_at FROM MovieRating AS mr LEFT JOIN Movies AS m ON mr.movie_id = m.movie_id LEFT JOIN Users AS u ON mr.user_id = u.user_id)(SELECT name AS resultsFROM RatingGROUP BY user_idORDER BY COUNT(*) DESC, name ASCLIMIT 1)UNION ALL(SELECT title AS resultsFROM RatingWHERE created_at >= '2020-02..

[문제]  [MySQL]SELECT p.product_name , SUM(o.unit) AS unitFROM Products AS p LEFT JOIN Orders AS o ON p.product_id = o.product_idWHERE o.order_date >= '2020-02-01' AND o.order_date = 100

[문제]  [MySQL]WITH daily AS ( SELECT visited_on , SUM(amount) AS daily_amount FROM Customer GROUP BY visited_on), moving_amount AS ( SELECT visited_on , LAG(visited_on, 6) OVER (ORDER BY visited_on) AS first_date , SUM(daily_amount) OVER (ORDER BY visited_on ROWS BETWEEN 6 PRECEDING AND CURRENT ROW) AS amount , ROUND(AVG(dail..