코드로 우주평화

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..

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..

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 ascii code of their first byte. e.g. Verlie = 86 Warren = 87 Horace = 72 Tracy = 84 Solution: SELECT id, ASCII(name) AS name, birthday, ASCII(race) AS race FROM demographics Result: id name birthday race..

Given the following table 'decimals': ** decimals table schema ** id number1 number2 Return a table with two columns (number1, number2), the value in number1 should be rounded down and the value in number2 should be rounded up. Solution: SELECT FLOOR(number1) as number1, CEIL(number2) as number2 FROM decimals Result: number1 number2 2409 -261 1411 -4694 2666 -2280 3616 -2987 4110 -2420 3654 -146..