On 13 Dec 1972, the final extra-vehicular activity (EVA) or "Moonwalk" to date began.

The LAST_VALUE function returns the final value in the window. Without the clause ROWS BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING, this returns the value from the current row rather than the final one in the table.

On 12 December 1901, Guglielmo Marconi received the first transatlantic radio signal (the letter "S" [•••] in Morse Code).

This statement uses the window clause, added in 21c, to define the named window atlantic, which includes all rows in the results. So this returns a list of the signal values for every row, on every row.

On 11 Dec 2009, the game Angry Birds was released on iOS.

This statement inserts the result of the query on the avians table.

The Treaty of Paris was signed on 10 October 1898 between Spain and the USA. As part of this agreement, Spain ceded control of Puerto Rico to the USA.

This swaps the data in the puerto_rico partition of the table spain with the data in the USA table.

On 9 December 1960, the first episode of Coronation Street aired on British TV. It is still running today, making it the world's longest-running TV soap opera.

This statement finds rows with a first_broadcast date of 9 December 1960 and a last_broadcast value of NULL. The IS NULL condition is necessary to identify this.

On 8 Dec 1995, the Council of Europe adopted the Flag of Europe: twelve gold stars on a blue field.

On 7 Dec 1995, the Galileo spacecraft, the first to orbit an outer planet, arrived at Jupiter.

This uses CONNECT BY to make a hierarchical query following the route Galileo took from Earth to Jupiter.

On 6 Dec 2006, NASA revealed photographs taken by Mars Global Surveyor suggesting the presence of liquid water on Mars.

This uses EXISTS to return the planets that have a row in the surface_water table.

On 5 Dec 1945, Flight 19, a group of five TBM Avenger torpedo bombers, disappeared over the Bermuda Triangle.

On 4 Dec 1791, the first edition of The Observer, the world's first Sunday newspaper, was published.

The “Dy” format model returns the three-letter abbreviation of the day of the week, so this loads all the Sundays in the dates table.

On 3 Dec 1910, neon lighting was first demonstrated by Georges Claude at the Paris Motor Show.

This joins the lights and gases tables. The using clause assumes both tables have a column named gas_id

On 2 December 1766, Swedish parliament approves the Swedish Freedom of the Press Act, thus becoming the first in the world with freedom of speech.

This grants the press user select, insert, update, delete, and foreign key privileges on the media table.

On 1 December 1913, the Buenos Aires Underground aka Subte began operation.

The first international football match was held at Hamilton Crescent, Glasgow, between Scotland and England.

This statement joins the home and away teams to the games table.

On 29 Nov 1899, Futbol Club Barcelona was formed.

This adds the Barcelona subpartition to the Spain partition of a *-list partitioned table.

On 27 November 1920, the film The Mark of Zorro was released in the USA.

On 26 Nov 2003, Concorde made its final flight.

On 25 Nov 1952, The Mousetrap opened at the Ambassadors Theatre in London's West End. It still runs today, making it the longest continuously running play in history.

It's Celebrate Your Unique Talent Day!

This adds a unique constraint to the talent column of the table people.

On 23 Nov 2005, Ellen Johnson Sirleaf was elected president of Liberia, becoming the first woman to lead an African country.

This statement grants the user ellen_sirleaf schema-level privileges on the schema liberia. The WITH ADMIN OPTION clause enables this user to manage these privileges for other users

It's the Day of the Albanian Alphabet, celebrating the Congress of Manastir, which established the Albanian alphabet on this day in 1908.

This statement sets the current session to use Albanian settings.

On 21 Nov 1905, Albert Einstein's paper, which led to the mass–energy equivalence formula, E = mc², was published in the journal Annalen der Physik.

This creates a use case domain to represent mass–energy equivalence.

Microsoft Windows 1.0 was released on 20 November 1985.

On 19 Nov 1969, Pete Conrad and Alan Bean became the third and fourth people to walk on the moon.

This uses the OFFSET clause to fetch the third and fourth in the sorted data set.

On 18 Nov 1985, the first Calvin and Hobbes comic was published in newspapers.

17 Nov 1868 is the start of the Modified Julian Date calendar. This is calculated as standard Jualian dates minus 2,400,000.

The “J” format in Oracle AI Database converts dates using the standard Julian calendar.

On 16 November 1945, The United Nations Educational, Scientific and Cultural Organization (UNESCO) was formed

It's Clean Out Your Refrigerator Day!

Clear out all the expired or untouched foods from your fridge, just like this statement removed rows with expired_on in the past.

On 14 November 1985, the discovery of C₆₀ (Buckminsterfullerene) was published in the journal Nature. This structure resembles a football with 12 pentagons
and 20 hexagons.

On 13 November 1994, in a referendum, Sweden voted to join the European Union.

This adds the list partition sweden to the table, which stores rows with the value “sweden”.

It's Happy Hour Day! A time when many bars and restaurants have reduced prices.

This statement reduces the price of a product by its discount percentage.

On 11 November 1521, Tycho Brahe observed the supernova SN 1572, often referred to as Tycho's Supernova.

On 10 November 1821, residents of the Azuero, Panama declared independence from the Spanish Empire. This eventually led to Panama joining the Republic of Colombia.

This statement swaps the data in the panama partition of the table spain with the data in the colombia table.

On 9 November 1994, the synthetic chemical element Darmstadtium was discovered.

This adds constraints ensuring that the values of symbol are unique and an uppercase letter, optionally followed by a lowercase letter.

It's Tongue Twister Day!

To celebrate, today's SQuizL is in the form of the popular tongue twister, “She sells sea-shells by the sea-shore”.

The column im_sure uses the Boolean data type, so “AND im_sure” returns all the rows where it's true.

On 7 November 1990, Mary Robinson was the first woman to be elected President of the Republic of Ireland.

On 6 November 1988, Grete Waitz won the New York Marathon for a record ninth time. This remains the record for the most marathon victories in a single city.

On 5 November 1940, Franklin D. Roosevelt became the first and only president of the USA to be elected for a third term.

On 4 November 1922, the entrance to the tomb of Tutankhamun was discovered in the Valley of the Kings in Egypt.

On 3 November 1957, the dog Laika became the first animal to travel into space aboard Sputnik 2.

On 2 November 1868, New Zealand adopted standard time nationwide.

This sets the database's time zone to Pacific/Auckland; this change takes effect after you restart the database.

The fresco painted by Michelangelo on the ceiling of the Sistine Chapel was first displayed to the public on 1 November 1512.

Sir Christopher Wren, one of the most highly acclaimed architects in the history of England, was born on 30 October 1632.

On 29th October 1969, the first computer-to-computer link was established on ARPANET, a development which eventually lead to the internet.

On 28 October 1900, the Games of the II Olympiad held in Paris ended after five months of events.

This statement updates the result of the subquery. In this case, the subquery is unnecessary; the statement could be written as

UPDATE olympics SET end_date = DATE'1900-10-28' WHERE city = 'Paris' 

27 October 1275 is considered the traditional foundation date of the city of Amsterdam. The first mention of Amsterdam appears in a document on this date which exempts its inhabitants from bridge tolls in the county of Holland.

On 26 October 1825, the Erie Canal, connecting Lake Erie to the Hudson River, was completed. The principal engineer was Benjamin Wright.

The Toronto Stock Exchange was formed on 25 October 1861.