코드로 우주평화

For this challenge you need to create a SELECT statement, this SELECT statement will use an IN to check whether a department has had a sale with a price over 98.00 dollars. departments table schema id name sales table schema id department_id (department foreign key) name price card_name card_number transaction_date resultant table schema id name Solution: SELECT id, name FROM departments WHERE i..

Given the following table 'decimals': decimals table schema id number1 number2 Return a table with two columns (abs, log) where the values in abs are the absolute values of number1 and the values in log are values from number2 in logarithm to base 64. Solution: SELECT ABS(number1), LOG(64, number2) FROM decimals Result: abs log 2849.529276973034 0.5513855124091469e1 168.16728863472508 0.53183827..

For this challenge you need to create a basic Increment function which Increments on the age field of the peoples table. The function should be called increment, it needs to take 1 integer and increment that number by 1. You may query the people table while testing but the query must only contain the function on your final submit. important: you must remove all comments when submitting the kata...

It's time to assess which of the world's greatest fighters are through to the 6 coveted places in the semi-finals of the Street Fighter World Fighting Championship. Every fight of the year has been recorded and each fighter's wins and losses need to be added up. Each row of the table fighters records, alongside the fighter's name, whether they won (1) or lost (0), as well as the type of move tha..

For this challenge you need to create a simple GROUP BY statement, you want to group all the people by their age and count the people who have the same age. people table schema id name age select table schema age [group by] people_count (people count) Solution: SELECT age, COUNT(age) AS people_count FROM people GROUP BY age Result: age people_count 8 10 4 7 1 16 5 8 3 7 0 9 9 13 6 12

Weekly growth 슬기로운 퀀트 투자 3~5 챕터 ➡️ 4 챕터까지 진행 5 챕터까지 진행하지 못하고 4 챕터까지만 진행했다. 오는 주에는 저녁시간에 더 집중해서 공부할 수 있도록 하자. 🚀 배우고 성장한 것 볼린저 밴드, 엔벨로프, MACD, RSI, 스토캐스틱 전략의 백테스트를 실습했다. 현재까지 퀀트 입문 과정을 블로그에 포스팅했다. 제 취미요? 퀀트입니다! 6월부터 취미로 퀀트를 배우기 시작했다. 퀀트가 뭔데? 🙂 Quant는 Quantitative(정량적)와 Analyst(분석가)의 합성어로 수학과 통계에 기반해 투자 모델을 만들거나 금융 시장 변화를 예측, 분석하는 daco2020.tistory.com 침대에서 평균 수면시간 8시간 ➡️ 7시간 33분 지난주보다는 수면시간이 늘었지만 아..

Nathan loves cycling. Because Nathan knows it is important to stay hydrated, he drinks 0.5 litres of water per hour of cycling. You get given the time in hours and you need to return the number of litres Nathan will drink, rounded to the smallest value. For example: hours = 3 ----> liters = 1 hours = 6.7---> liters = 3 hours = 11.8--> liters = 5 You have to return 3 columns: id, hours and liters..

6월부터 취미로 퀀트를 배우기 시작했다. 퀀트가 뭔데? 🙂 Quant는 Quantitative(정량적)와 Analyst(분석가)의 합성어로 수학과 통계에 기반해 투자 모델을 만들거나 금융 시장 변화를 예측, 분석하는 것을 말한다. 퀀트 투자와 일반 투자의 다른 점은 퀀트는 정량적인 데이터를 기반으로 수학과 통계를 이용해 투자를 한다는 것이다. 퀀트는 수학과 통계를 바탕으로 투자 전략을 만들고 백테스팅을 거쳐 검증할 수 있다. 검증된 전략을 바탕으로 프로그램을 만들어 실제 투자에 적용할 수 있다. 글로만 보면 이해가 안 될 테니 아래 *볼린저밴드를 활용한 *백테스팅 사례를 살펴보자. ❗️들어가기 전에 잠깐 용어 설명 *백테스팅 : 투자 전략을 과거 데이터에 적용하여 수익성을 평가하는 테스트 기법. *볼린저..

Very simple, given an integer or a floating-point number, find its opposite. Examples: 1: -1 14: -14 -34: 34 You will be given a table: opposite, with a column: number. Return a table with a column: res. Solution: SELECT number * -1 AS res FROM opposite Below is a method to solve uselessly and difficultly using CASE and SIGN. The 'SIGN' function tells whether the number is negative or positive w..

Deep within the fair realm of Lothlórien, you have been asked to create a shortlist of candidates for a recently vacated position on the council. Of so many worthy elves, who to choose for such a lofty position? After much thought you decide to select candidates by name, which are often closely aligned to an elf's skill and temperament. Choose those with tegil appearing anywhere in their first n..