Dev_Scripts

사용할 예제대장균 크기에 따라 분류하기2https://school.programmers.co.kr/learn/courses/30/lessons/3016491. ROW_NUMBER()WITH RANK_COLONY AS (SELECT ROW_NUMBER() OVER (ORDER BY SIZE_OF_COLONY DESC) AS 순위, ID, COUNT(*) OVER() AS TOTAL_COUNTFROM ECOLI_DATA)SELECT ID, CASE WHEN 순위 2. RANK()WITH RANK_COLONY AS (SELECT RANK() OVER (ORDER BY SIZE_OF_COLONY DESC) AS 순위, ID, COUNT(*) OVER() AS TOTAL_COUNTFROM ECOLI_DATA..

재구매가 일어난 상품과 회원 리스트 구하기https://school.programmers.co.kr/learn/courses/30/lessons/131536#답1SELECT DISTINCT A.USER_ID, A.PRODUCT_ID FROM ONLINE_SALE A, ONLINE_SALE BWHERE A.USER_ID = B.USER_ID AND A.PRODUCT_ID = B.PRODUCT_ID AND A.ONLINE_SALE_ID != B.ONLINE_SALE_IDORDER BY USER_ID, PRODUCT_ID DESC#답2SELECT USER_ID, PRODUCT_ID FROM ONLINE_SALEGROUP BY USER_ID, PRODUCT_ID #두개가 한그룹(둘다 같아야 하나의 그룹으로 인정..

Exercise v3.0 (w3schools.com)SELECT#1SELECT * FROM Customers#2SELECT City from Customers#3SELECT DISTINCT Country FROM CustomerWHERE#1select * from Customerswhere City = "Berlin"#2select * from Customerswhere CustomerID = 32ORDER BY#1Select * From CustomersOrder by City#2select * from Customersorder by City desc#3select * from Customersorder by Country, CityAND OR NOT#1 Select * From Customerswh..