MySQL - Combining the max and concat functions
<p>My SQL table has information on book titles, and I want to select the book that has the highest price, and I also want to display 'The most expensive book costs $xx.xx’</p>

<p>Here is the code of the table</p>

<pre><code>CREATE TABLE titles
  (
  title_id   CHAR(3)      NOT NULL,
  title_name VARCHAR(40)  NOT NULL,
  type       VARCHAR(10)          ,
  pub_id     CHAR(3)      NOT NULL,
  pages      INTEGER              ,
  price      DECIMAL(5,2)         ,
  sales      INTEGER              ,
  pubdate    DATE                 ,
  contract   SMALLINT     NOT NULL,
  CONSTRAINT pk_titles PRIMARY KEY (title_id)
  )ENGINE = InnoDB;
</code></pre>

<p>I have tried the code below and it does not work.</p>

<pre><code>SELECT CONCAT(MAX('The most expensive book costs ', price)) FROM titles;
</code></pre>

<p>Any tips?</p>