코드로 우주평화

Given the following table 'decimals': decimals table schema id number1 number2 Return a table with a single column result which is the output of number1 raised to the power of number2. Solution: SELECT POWER(number1, number2) as result FROM decimals The 'POWER' function returns the value raised to the power of the first argument by the second argument.

You will need to create SELECT statement in conjunction with LIKE. Please list people which have first_name with at least 6 character long names table schema id first_name last_name results table schema first_name last_name Solution: SELECT first_name, last_name FROM names WHERE first_name LIKE '______%' Percent Sign (%): represents zero or more unspecified characters Under Score(_) : Represents..

Using our monsters table with the following schema: monsters table schema id name legs arms characteristics return the following table: ** output schema** name characteristics Where the name is the original string repeated three times (do not add any spaces), and the characteristics are the original strings in reverse (e.g. 'abc, def, ghi' becomes 'ihg ,fed ,cba'). Solution: SELECT REPEAT(name,3..

You have access to a table of monsters as follows: monsters schema id name legs arms characteristics In each row, the characteristic column has a single comma. Your job is to find it using position(). You must return a table with the format as follows: output schema id name comma The comma column will contain the position of the comma within the characteristics string. Order the results by comma..

Weekly growth 슬기로운 퀀트 투자 1, 2 챕터 이번 주에는 3 챕터까지 공부하려 했으나, 약속이 많아 시간이 부족해 2 챕터까지만 공부했다. 배우고 성장한 것 퀀트의 개념을 알게 되었다. 실제 코드를 작성하여 차트를 확인할 수 있게 되었다. 백테스팅 결과를 확인하고 각 항목들이 무엇을 의미하는지 알게 되었다. 보완할 것 목표를 달성하여면 더 빠른 속도로 공부해야 한다. 더 많은 시간 투자가 필요하다. 침대에서 평균 수면시간 8시간 평균 6시간 53분으로 이전보단 나아졌지만 아직 8시간에는 못 미치고 있다. 배우고 성장한 것 이전보다 침대에서의 평균 수면시간이 증가했다. 보완할 것 저녁에 약속이 있으면 늦게 잠들게 된다. 저녁 약속을 줄이자. 늦게 잠들면 아침에 운동을 못한다. 11시에는 무조..

You received an invitation to an amazing party. Now you need to write an insert statement to add yourself to the table of participants. participants table schema name (string) age (integer) attending (boolean) NOTES: Since alcohol will be served, you can only attend if you are 21 or older You can't attend if the attending column returns anything but true NOTE: Your solution should use pure SQL. ..

#Greetings Grasshopper!# Using only SQL, write a query that returns all rows in the custid, custname, and custstate columns from the customers table. ###Table Description for customers:### ColumnData TypeSizeSample custid integer 8 4 custname string 50 Anakin Skywalker custstate string 50 Tatooine custard string 50 R2-D2 Solution: SELECT custid, custname, custstate FROM customers

Simple, remove the spaces from the string, then return the resultant string. Solution: SELECT x, REPLACE(x, ' ', '') AS res FROM nospace Result: x res 8 j 8 mBliB8g imjB8B8 jl B 8j8mBliB8gimjB8B8jlB 8 8 Bi fk8h B 8 BB8B B B B888 c hl8 BhB fd 88Bifk8hB8BB8BBBB888chl8BhBfd 8aaaaa dddd r 8aaaaaddddr jfBm gk lf8hg 88lbe8 jfBmgklf8hg88lbe8

You are a border guard sitting on the Canadian border. You were given a list of travelers who have arrived at your gate today. You know that American, Mexican, and Canadian citizens don't need visas, so they can just continue their trips. You don't need to check their passports for visas! You only need to check the passports of citizens of all other countries! Select names, and countries of orig..

Given a demographics table in the following format: ** demographics table schema ** id name birthday race you need to return the same table where all text fields (name & race) are changed to the bit length of the string. Solution: SELECT id, BIT_LENGTH(name) AS name, birthday, BIT_LENGTH(race) AS race FROM demographics Result: id name birthday race 1 40 1983-01-30 200 2 40 1974-09-15 200 3 40 19..