FabricOfData

Given a word, write a SQL query to find and display the distinct vowels (A, E, I, O, U) present in that word. …

SQL Puzzles

SAS

Given a word (e.g., 'FABRICOFDATA'), write a SQL query to output each row of a right-angled triangle, where each row displays the first N characters of the word …

SQL Puzzles

SAS

Ever encountered an arithmetic overflow error while inserting data into a DECIMAL column in SQL Server? In this SQL puzzle, we intentionally trigger this error by inserting values to Decimal Column and under…

SQL Puzzles

SAS

In this SQL puzzle, we challenge you to determine the fiscal year in which an employee joined a company, considering that the fiscal year runs from April to March Input Data: Tap Fo…

SQL Puzzles

SAS

In real-world coding scenarios, we are often tasked with identifying all tables that contain a specific column name. This is a critical step when preparing for the next phase of changes or development in a project. In this bl…

SQL Puzzles

SAS

List the movies that have exactly two different villains. check the Sample data and expected output below. Input Data: Tap For Closer Look Expected Output: …

SQL Puzzles

SAS

How can we ensure that, based on the provided dataset below, 'Hyderabad' always appears in the first row of the 'StateCapital' column, with the remaining column values sorted in ascending order. Input D…

SQL Puzzles

SAS

From the provided employee data, identify employees whose salaries are below the department's average salary, and determine the percentage of salary increase required to reach the average departmental salary. Input…

SQL Puzzles

SAS

Determine, from the provided employee data, which employees have the highest and lowest salaries within each department. Input Data: Tap For Closer Look Expected Output:…

SQL Puzzles

SAS

Question: Find the rows that have more than one NULL value across its columns. check below the sample data and expected output. Input Data: Tap For Closer Look Expected Output: …

SQL Puzzles

SAS

XYZ, the renowned online retail platform, requires customers to create an account to browse and purchase items of their choice. In this analysis, our objective is to pinpoint the new customers who have joined in the current month. H…

SQL Puzzles

SAS