Database Design (SQL)

I ned help creating a query that shows the number of days left before the end of the term. I need the following functions to accomplish this: CONCAT, DAYOFYEAR, NOW. So far I have this for my query:

SELECT CONCAT('There are ',DAYOFYEAR(NOW()),' ',DAYOFYEAR(NOW())) AS `Days Left`;

The result is supposed to say: There are 69 days left before school ends for the spring term!!!

The result I got was: There are 79 79

  1. 👍 0
  2. 👎 0
  3. 👁 116

Respond to this Question

First Name

Your Response

Similar Questions

  1. Math

    When you are translating a number from scientific notation to standard form, what does the exponent tell you? The number of zeros to add to the end of the original number the number of places to move the decimal point to the left

  2. Math

    Ms. Carter recorded the number of sick days taken last year by each employee, as shown in the table. What is the mean number of days employees were sick? Round to the nearest hundredth A.3.63 days B.2 days C.3.22 days D.3 days

  3. Math

    The Department manager recorded the number of sick days taken laster year by each employee, What is the mean number of days employees were sick? Round to the nearest hundredth. 2.86 days**** 2.57 days 2.43 days 2.29 days

  4. Statistics

    A number of people were asked how many days they would wait to seek medical treatment if they were suffering pain that interfered with their ability to work. The results are presented in the following table. Number of days: 0 , 1

  1. statistics

    Data on number of days of work missed and annual salary increase for a company's employees show that in general exployees who missed more days of work during the year received smaller raises than those who missed fewer days. A

  2. Mathematics

    When you are translating a number from scientific notation to standard form, what does the exponent tell you? The number of zeros to add to the end of the original number the number of places to move the decimal point to the left

  3. stats

    Data on number of days of work missed and annual salary increase for a company's employees show that in general exployees who missed more days of work during the year received smaller raises than those who missed fewer days. A

  4. Statistics 2

    In Hamilton County, Ohio the mean number of days needed to sell a home is 86 days (Cincinnati Multiple Listing Service, April, 2012). Data for the sale of 40 homes in a nearby county showed a sample mean of 80 days with a sample

  1. Math

    Eighteen students in a class play baseball. Seventeen students in the class play basketball. Thirty students in the class plau either or both sports. Select the Venn diagram that shows the number of students who play basketball

  2. half-life of radioisotope

    A radioisotope has a half-life of 4 days. How much of a 20-gram sample of this radioisotope remains at the end of each time period? 1) 4 days 2) 8 days

  3. physics

    Two blocks, each of mass m, are attached to the ends of a massless rod which pivots as shown in Figure 8-40. Initially the rod is held in the horizontal position and then released. Calculate the magnitude and direction of the net

  4. Math

    (05.03 MC) Lisa reads an equal number of pages of a book every week. The graph below shows the number of pages of the book left to read, y, after x weeks: A graph titled Lisas Book Reading shows Number of Weeks on the x-axis and

You can view more similar questions or ask a new question.