코드로 우주평화

or this challenge you need to create a simple SELECT statement that will return all columns from the people table, and join to the toys table so that you can return the COUNT of the toys people table schema id name toys table schema id name people_id You should return all people fields as well as the toy count as "toy_count". Solution: SELECT p.id, p.name, COUNT(t.name) AS toy_count FROM people ..

For this challenge you need to create a simple HAVING statement, you want to count how many people have the same age and return the groups with 10 or more people who have that age. people table schema id name age return table schema age total_people Solution: SELECT age, COUNT(age) AS total_people FROM people GROUP BY age HAVING COUNT(age) >= 10 Result: age total_people 16 13 54 11 47 14 99 11 4..

Hello SQL! Return a table with a single column named Greeting with the phrase 'hello world!' Please use Data Manipulation Language and not Data Definition Language to solve this Kata Solution: SELECT 'hello world!' AS "Greeting" The reason 'Greeting' is enclosed in double quotation marks is that uppercase letters are changed to lowercase letters unless they are enclosed in double quotation marks..

Weekly growth 클린 코더스 스터디 이번 주에는 6강 ~ 10강까지 들었다. 오는 주에 동료들과 의견을 나눌 예정이다. 주식 투자 자동화 튜토리얼 끝내기 조코딩 영상을 보고 튜토리얼을 끝냈다. 한국투자증권 계좌를 만들었고 API 키를 생성해 환경변수 세팅을 완료했다. 앞으로 몇가지 전략을 세팅하고 실제 자동매매를 구현할 생각이다. 피맥챗 목요일, 글또 커뮤니티를 통해 외부 개발자 다영님, 찬주님과 피맥챗을 했다. 각각 신입, 3년차, 5년차 개발자였는데 연차는 달라도 개발자끼리는 금방 친해지는 것 같다! 선배 개발자들은 어떤 생각과 고민을 하는지 알 수 있었고 '기술', '문화', '관계' 등의 주제로 다양한 생각과 의견을 나누었다. 앞으로도 종종 외부개발자들을 만나 시야를 넓혀야겠다. Next..

You are the owner of the Grocery Store. All your products are in the database, that you have created after CodeWars SQL excercises!:) You have reached a conclusion that you waste to much time because you have to many different warehouse to visit each week. You have to find out how many different type of products you buy from each producer. If you take only few items from some of them you will st..

You are given a table named repositories, format as below: ** repositories table schema ** project commits contributors address The table shows project names of major cryptocurrencies, their numbers of commits and contributors and also a random donation address ( not linked in any way :) ). Your job is to remove all numbers in the address column and replace with '!', then return a table in the f..

Overview For this kata we will be using the DVD Rental database. You are working for a company that wants to reward its top 10 customers with a free gift. You have been asked to generate a simple report that returns the top 10 customers by total amount spent ordered from highest to lowest. Total number of payments has also been requested. The query should output the following columns: customer_i..

You are given a table named repositories, format as below: ** repositories table schema ** project commits contributors address The table shows project names of major cryptocurrencies, their numbers of commits and contributors and also a random donation address ( not linked in any way :) ). For each row: Return first x characters of the project name where x = commits. Return last y characters of..

You have access to two tables named top_half and bottom_half, as follows: top_half schema id heads arms bottom_half schema id legs tails You must return a table with the format as follows: output schema id heads legs arms tails species The IDs on the tables match to make a full monster. For heads, arms, legs and tails you need to draw in the data from each table. For the species, if the monster ..

For this challenge you need to create a SELECT statement, this select statement must have NULL handling, using COALESCE and NULLIF. If no name is specified you must replace with [product name not found] If no card_name is specified you must replace with [card name not found] If no price is specified you must throw away the record, you must also filter the dataset by prices greater than 50. eusal..