Programmers

MySQL) 언어별 개발자 분류하기

SELECT GRADE, ID, EMAIL FROM ( WITH CTE AS( SELECT d.ID, d.EMAIL, MAX(CASE WHEN s.CATEGORY = 'Front End' THEN 1 ELSE 0 END) AS has_front, MAX(CASE WHEN s.NAME = 'Python' THEN 1 ELSE 0 END) AS has_python, MAX(CASE WHEN s.NAME = 'C#' THEN 1 ELSE 0 END) AS has_csharp FROM DEVELOPERS d JOIN SKILLCODES s ON d.SKILL_CODE..

MySQL) 식품분류별 가장 비싼 식품의 정보 조회하기

WITH CTE AS(SELECT CATEGORY, MAX(PRICE) AS MAX_PRICEFROM FOOD_PRODUCTWHERE CATEGORY IN ('과자', '국', '김치', '식용유')GROUP BY CATEGORY)SELECT CTE.*, PRODUCT_NAMEFROM CTEJOIN FOOD_PRODUCT P ON CTE.MAX_PRICE = P.PRICE AND CTE.CATEGORY = P.CATEGORYORDER BY PRICE DESC

MySQL) 5월 식품들의 총매출 조회하기

SELECT P.PRODUCT_ID, P.PRODUCT_NAME, SUM(PRICE * AMOUNT) AS TOTAL_SALESFROM FOOD_PRODUCT PLEFT JOIN FOOD_ORDER O ON P.PRODUCT_ID = O.PRODUCT_IDWHERE YEAR(PRODUCE_DATE) = 2022 AND MONTH(PRODUCE_DATE) = 5GROUP BY P.PRODUCT_IDORDER BY TOTAL_SALES DESC, P.PRODUCT_ID ASC;

C#) 마지막 두 원소

using System;using System.Collections.Generic;using System.Linq;public class Solution { public int[] solution(int[] num_list) { List answer = new List(); answer = num_list.ToList(); int last = num_list[num_list.Length-1]; int beforeLast = num_list[num_list.Length-2]; answer.Add(last>beforeLast ? last - beforeLast : last *2); return..

C# ) 두 수의 연산값 비교하기

using System;public class Solution { public int solution(int a, int b) { int test1 = 2 * a * b; int test2 = int.Parse($"{a}{b}"); return Math.Max(test1, test2); }}

C#) A강조하기

using System;public class Solution { public string solution(string myString) { string answer = ""; char[] chars = myString.ToCharArray(); for(var i=0; i

C#) 문자열 섞기

using System;public class Solution { public string solution(string str1, string str2) { string answer = ""; char[] a = str1.ToCharArray(); char[] b = str2.ToCharArray(); for(var i=0; i

C#) 문자열 겹쳐쓰기

using System;public class Solution { public string solution(string my_string, string overwrite_string, int s) { string answer = ""; answer = my_string.Substring(0, s) + overwrite_string + my_string.Substring(s + overwrite_string.Length); return answer; }}

C#) 대소문자 바꿔서 출력하기

using System;public class Example{ public static void Main() { String s; Console.Clear(); s = Console.ReadLine(); char[] chars = s.ToCharArray(); char[] test = new char[chars.Length]; for(var i=0; i

MySQL) 주문량이 많은 아이스크림들 조회하기

WITH CTE AS ( SELECT J.FLAVOR, SUM(J.TOTAL_ORDER) + IFNULL(SUM(F.TOTAL_ORDER), 0) AS TOTAL_ORDER FROM JULY J LEFT JOIN FIRST_HALF F ON J.SHIPMENT_ID = F.SHIPMENT_ID GROUP BY J.FLAVOR)SELECT FLAVORFROM CTEORDER BY TOTAL_ORDER DESCLIMIT 3;