Category: Tutorials
-
Conditional Mass Update of Data in Google Sheets Using SQL
Categories: TutorialsOne of the tasks that cannot be solved using standard Google Sheets tools but can be handled with an SQL query is mass updating data with conditions. For example: Task: Increase the Annual Salary by 10% for all employees working in the “IT” department who have more than 5 years of tenure. SQL query for…
-
SQL in Google Sheets: Calculating Salary Shares using window functions
Categories: TutorialsGoogle Sheets is a powerful tool, but some advanced tasks—like calculating an employee’s salary as a percentage of their department’s total—can be challenging. SQL, especially with window functions, makes this analysis straightforward. The Challenge Given a dataset with employee details (id, name, department, and salary), calculating salary shares in Sheets requires manual grouping, matching, and…