Published in


An Advanced SQL Syntax That Saved Me From Using Python

I almost opened my PyCharm at that time

Image by Dean Moriarty from Pixabay

Last month, my boss asked me to check out which users uploaded too many videos on our server. Because the storage of the server grew so fast.

Easy-peasy. Cause there is a table called t_video in our MySQL database. The definition of columns looks like the following:

Technology gives us more and more freedom. Start learning today.

Recommended from Medium

Serverless Slack Bot

RESTful Patterns & Principles

How I failed Amazon interview (MLE)

Creating an AI Waypoint System on the Scene View by using OnDrawGizmos

Grammar Grasp 3: 에 and 에서

Formik Hooks Ant Design Select Set Value

Remove K From List — codesignal Algorithms problem regarding Linked Lists

Good fortune? A twist of fate?- An unexpected but rewarding first two years with Agilent

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Yang Zhou

Yang Zhou

🇺🇦 I’m a full-stack engineer who also writes.

More from Medium

8 Essential Python Techniques for Data Engineers and Analysts (with code samples)

Python Data Classes, will save you hours of development!

A Look at the SQL Speaking Python… Pandas!

Keeping Your Data Pipelines Organized