Readable Book Due Dates

Problem

Table: `DueDates`

```text
+-------------+------+
| Column Name | Type |
+-------------+------+
| due_on | date |
+-------------+------+
due_on is the primary key for this table.
Each row is the date a borrowed library book must be returned.
```

The library wants to print friendly reminder slips. Write a solution to turn each `due_on` date into a human-readable string of the form `'weekday, month day, year'`, for example `'Tuesday, March 14, 2023'`.

The weekday and month must be full English names, the day has no leading zero, and the year is the four-digit number.

Return the result table in any order. Name the output column `due_label`.

Tables

Example rows — the live problem includes the full dataset.

Expected output

Your answer should return 3 rows with the columns due_label.

Starter code (SQL)

SELECT *
FROM DueDates;

Related SQL questions

• Above-Average CampusesEasy
• Adjacent Open Parking SpotsEasy
• App Ad Click-Through RateEasy
• Asset Labels With a Three-Digit CodeEasy
• Average Listening Sessions per ListenerEasy
• Average Nightly Rate Earned per RoomEasy