Skulevo Village 🔥

After a long journey, we finally reached Skulevo Village.
Life goes on as usual here.

At the gates, they argue about functions, operations, and schedulers.
At the tavern, men laugh loudly at a tale about a daredevil who did DROP DATABASE on Friday and was looking for a new job by Monday.

Near the market, shady characters are hanging around. No doubt they are bandits. From their conversation, you can hear:
SELECT * without LIMIT to the liver. The database is not eternal.

A strange place. But to gain wisdom, you can turn a blind eye to this 🤔

At the entrance, every traveler is given a scroll. At the very top of the scroll is an announcement:

The wood master Plotnikov's shop needs an assistant bookkeeper.
The local master is ready to teach the accounting trade.
No experience required. A head on your shoulders is desirable 😁

Below is a brief summary of the rules of SQL Village.
1️⃣ First Rule
SQL is a language for asking questions to data.

2️⃣ Second Rule
Local scrolls are called tables.

3️⃣ Third Rule
Every query must answer a specific question.

4️⃣ Fourth Rule
SELECT * without need is a bandit's habit.

5️⃣Fifth Rule
A query without verification is like fortune-telling with wood chips.

Now it's time to go to the shop. Master Plotnikov is already waiting.
Scrolls are on the table. The accounts, of course, don't add up 🤦‍♂️

I'll gather a database of scrolls for skill practice.
Each new post will be one task from the life of the shop 😎

#sql

@data_dzen 🙂

Reminder: today at 19:00 MSK there will be a webinar on the topic "Old Excel still can".
Meeting link:
us06web.zoom.us/j/83865573817