Implementing Better Scroll Behavior in Cypress
Yesterday, Gleb Bahmutov demonstrated a more effective scroll behavior method in Cypress in his new YouTube video. As an avid […]
UNION UNION vs UNION ALL: Simplifying Data Combination in SQL
When combining the results of two tables with identical columns, we have to join the rows. That’s where UNION comes
UNION UNION vs UNION ALL: Simplifying Data Combination in SQL Read More »
Efficient WebSocket Traffic Tracking in Cypress
One of Cypress’s strengths is its ability to mock and test WebSocket traffic, which is crucial for real-time applications. However,
Handling Visibility Issues in Cypress Tests: A Case Study
When writing automated tests with Cypress, you might encounter issues where elements are not interactable due to their visibility on
Handling Visibility Issues in Cypress Tests: A Case Study Read More »
Simple SQL exercises for Data Enthusiasts: Counting, Summing, and Averaging City Populations
Task 1 Query a count of the number of cities in CITY having a Population larger than 100.000. The CITY table is described as follows: Field Type ID NUMBER
Step-by-Step Guide: Finding Prime Numbers with MySQL
The Task Write a query to print all prime numbers less than or equal to 1000. Print your result on
Step-by-Step Guide: Finding Prime Numbers with MySQL Read More »
Solving Project Conundrums with Consecutive Task Analysis in MySQL
The Task You are given a table, Projects, containing three columns: Task_ID, Start_Date and End_Date. It is guaranteed that the difference between the End_Date and the Start_Date is equal
Solving Project Conundrums with Consecutive Task Analysis in MySQL Read More »
SQL Challenge: Sorting Students by Grades
The Task You are given two tables: Students and Grades. Students contain three columns: ID, Name, and Marks. Column Type ID Integer Name String
Crafting a Leaderboard with SQL: A Coding Contest Case Study
The Task Julia just finished conducting a coding contest, and she needs your help assembling the leaderboard! Write a query
Crafting a Leaderboard with SQL: A Coding Contest Case Study Read More »
Managing Corporate Hierarchies with SQL: A Case Study
The Task Our conglomerate corporation just acquired some new companies. Each of the companies follows this hierarchy: Given the
Managing Corporate Hierarchies with SQL: A Case Study Read More »
Not too simple SQL exercises
“Higher Then” Queries Query the Name of any student in STUDENTS who scored higher than Marks. Order your output by the last three characters of each name.
Sorting SQL Query Exercises
Two results set queries Generate the following two result sets: Note: There will be at least two entries in the table