How to compose a query in SQl as a string?

Question

SQL

How to write a query that will return the result in the form of a table (not a row!) Of 12 rows, each row has 2 columns, in one column the month of the current year, in the other - the number of days in the month. In the query, do not use existing tables from the database, including temporary ones, i.e. query should work immediately from any SQL console?

Answer 1

SELECT 'Январь', 31
UNION
SELECT 'Февраль', 29
....

take leap years into account