SQL Tip: How Order By Works with Multiple Columns When using ORDER BY with multiple columns, the database initially sorts the entire result set based on the first column specified (the sales column in this case). This creates "groups" of rows that have the same value for the first column; e.g., rows that have a sales value of 12,000. The secondary sort (age ASC), unlike the first sort that is applied to the entire table, will be applied to the groups. In this output, you can see that rows with the same sales value have been grouped. For example, Mira and Bob have been grouped because they have the same sales value (12,000). The primary sort, based on the sales column in descending order, resulted in a tie between Mira and Bob. The secondary sort serves as the tiebreaker. Since we are sorting by the age column in ascending order, Mira, who is 30, is placed before Bob. This process is repeated for all tied values in the primary sort. #DataAnalytics

👉Give it a TRY and let us know the answer in Comment section🙋‍♀️🙋⏰ . #Python #Programming #Coding #pythonprogramming #100DaysofCode #pythonquiz #logicalpython

👉Give it a TRY and let us know the answer in Comment section🙋‍♀️🙋⏰ . #Python #Programming #Coding #pythonprogramming #100DaysofCode #pythonquiz #logicalpython

Python Question Can you figure out what `puzzling_fun` does, and what is the output of the code snippet?

Understanding execution order of SQL queries! Before you can optimize SQL queries, you must understand their order of execution! The order of execution is different from how you write it, here's the actual order: 1️⃣ FROM: Determines the tables of interest 2️⃣ JOIN: Joins the tables of interest as per specification and sets up the base data. 2️⃣ WHERE: Applies a filter to the rows returned from the FROM clause. It restricts the result set to only those rows that meet a specified condition 3️⃣ GROUP BY: Groups rows that have the same values in specified columns. It is often used with aggregate functions ( eg. COUNT, MAX, MIN, SUM, AVG) to perform calculations on each group. 4️⃣ HAVING: Similar to the WHERE clause, but it is used to filter groups based on aggregate functions. It is applied after the GROUP BY clause. 5️⃣ SELECT: Used to specify the columns from the filtered results to display in the query's result set. It can include column names, aggregate functions, and expressions. 6️⃣ ORDER BY: Sorts the result set returned by the query in ascending (ASC) or descending (DESC) order based on one or more columns. 7️⃣ LIMIT: Restricts the number of rows returned by the query. _________ That's a wrap! If you interested in: • Python 🐍 • ML/MLOps 🛠 • CV/NLP 🗣 • LLMs 🧠 • AI Engineering ⚙️ Find me → @akshay_pachaar ✔️ Everyday, I share tutorials on above topics! I also write a weekly Newsletter on AI Engineering, link in the next tweet! Cheers!! 🙂

Python tip; How to blur an image using the Python libraries scipy and imageio

The following queries may give different results; do you know why? #SQL #SQLServer Reply with your answer!

This is a remarkable video of an incredible man who climbs a giant chimney, tasked with destroying it, one brick at a time. Listen to this courageous man who is grateful, optimistic and hard working

How losing weight and exercise impacts your body and brain

Delete one forever:

Big python in Australia #python #pet #cat #dog #cute #animals #followback #funny #followforyou #fyp #trend #usa #cheo #ElonMusk #parasites