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 »
The Task You are given two tables: Students and Grades. Students contain three columns: ID, Name, and Marks. Column Type ID Integer Name String
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 »
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 »
“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.
Two results set queries Generate the following two result sets: Note: There will be at least two entries in the table
Query the list of # starting with vowels Query the list of CITY names beginning with vowels (i.e., a, e, i, o, or u) from STATION. Your result cannot contain
Let’s jump to the first task! Query all columns for all American cities in the CITY table with populations larger than 100000. The CountryCode for
Today I was asked to do a Cypress testing of the IQOS website. The task was to test the fastest
Here, I will demonstrate a short Cypress testing procedure for the search bar on a news website. The search bar
Cypress Test Case: Informer News Website Search Bar Read More »
I will demonstrate how to test the Soft Age Gate feature with Cypress in this article. I will use the
Here, I have prepared a Cypress exercise for a distinct case when we want to interact with a specific button
Cypress Excercise: Interacting with a Specific Button on the webpage Read More »