-- 다음 문자열을 역순으로 한 후 대문자로 변경하시오.
SELECT
UPPER(REVERSE ('Hello World'));
-- 다음은 어떻게 출력되는가?
SELECT
REPLACE (CONCAT ('I', ' ', 'like', ' ', 'cats'), ' ', '-');
-- 타이틀에서 공백을 -> 로 변경하시오.
SELECT
REPLACE (title, ' ', '->') as title
FROM
books;
-- author_lname을 순방향과 역방으로 출력하시오.
SELECT
author_lname as forwords,
REVERSE (author_lname) as backwards
FROM
books;
-- author_fname과 author_lname을 합치고 대문자로 변경하시오.
SELECT
UPPER(CONCAT (author_fname, ' ', author_lname)) as 'full name in caps'
FROM
books;
-- 제목과 출판일을 합치시오.
SELECT
CONCAT (title, ' was released in ', released_year) as blurb
FROM
books;
-- title의 길이를 출력하시오.
SELECT
title,
CHAR_LENGTH(title) as 'title length'
FROM
books;
-- short title, author, quantity 를 보이세요.
SELECT
CONCAT (SUBSTR (title, 1, 10), '...') AS 'short title',
CONCAT (author_lname, ', ', author_fname) AS 'author',
CONCAT (stock_quantity, ' in stock') AS 'quantity'
FROM
books;
SELECT * FROM books;