**Tutorials, Exercises published recently**

**29 November, 2022**

JavaScript: Longest common subsequence

JavaScript: Longest Valid Parentheses

JavaScript: Longest Palindromic Subsequence

JavaScript: Reverse a Binary string

**28 November, 2022**

JavaScript: All prime factors of a given number

JavaScript: Check sum of consecutive positive integers

JavaScript: Hexadecimal number to binary equivalent

**27 November, 2022**

C Programming: Remove a file from the disk

C Programming: File read and write using variable

C Programming: File modification time

**26 November, 2022**

SQL AdventureWorks: Find all rows outside a specified range of rate

SQL AdventureWorks: Retrieve rows whose datetime values are between '20111212' and '20120105'

SQL AdventureWorks: Returns TRUE even if NULL is specified in the subquery

SQL AdventureWorks: Get employees with Johnson last names

**25 November, 2022**

C++ Math: Number of arithmetic slices in an array of integers

C++ Math: Number as the multiplication of its prime factors

C++ Math: Generate sequence of primes by means of trial division

**24 November, 2022**

SQL AdventureWorks: Tax difference between highest and lowest-taxed state or province

SQL AdventureWorks: Calculate sales targets per month for salespeople

SQL AdventureWorks: Find unit price, ID number, and modulus of division

SQL AdventureWorks: Find marketing Assistants with more than 41 vacation hours

**23 November, 2022**

SQL AdventureWorks: A distinct businessentityid must be returned by both queries

SQL AdventureWorks: Any distinct businessentityid from the first query not found in the second query

SQL AdventureWorks: Combine ProductModelID and Name columns from two tables

SQL AdventureWorks: Add vacation and sick time to find total hours away from work

**22 November, 2022**

C++ Linked List: Insert a new node at the end of a Doubly Linked List

C++ Linked List: Middle element of a Doubly Linked List

C++ Linked List: Insert new node at the middle of a Doubly Linked List

**21 November, 2022**

C++ Linked List: Create and display a doubly linked list

C++ Linked List: Reverse doubly linked list

C++ Linked List: Count number of nodes in a doubly linked list

C++ Linked List: Insert a node at the beginning of a Doubly Linked List

**20 November, 2022**

C++ Linked List: Delete a middle node from a Singly Linked List

C++ Linked List: Delete the last node of a Singly Linked List

C++ Linked List: Delete the nth node of a Singly Linked List from end

C++ Linked List: Kth node from the Middle towards Head of a Linked List

**19 November, 2022**

C++ Linked List: Find middle element in a single linked list

C++ Linked List: Insert new node at the middle of a Singly Linked List

C++ Linked List: Get Nth node in a Singly Linked List

C++ Linked List: Insert a node at any position of a Singly Linked List

C++ Linked List: Delete first node of a Singly Linked List

**18 November, 2022**

C++ String: Find Unique Character String

C++ String: Select lowercase characters from the other string

C++ String: Second occurrence of a string within another string

C++ String: Alternate the case of each letter in a string

**17 November, 2022**

C++ Linked List: Create and display linked list

C++ Linked List: Reverse linked list

C++ Linked List: Count number of nodes in a linked list

C++ Linked List: Insert a new node at the beginning of a Linked List

C++ Linked List: Insert a new node at the end of a Linked List

**16 November, 2022**

SQL AdventureWorks: Check for similarity of the values

SQL AdventureWorks: Return any distinct values that are returned by both the queries

SQL AdventureWorks: Return any distinct values from first query, not found on the 2nd query

**15 November, 2022**

SQL AdventureWorks: Display the list price as a comment based on the price range

SQL AdventureWorks: Change the display of product line categories with comment

SQL AdventureWorks: Evaluate whether the values in two columns are the same

SQL AdventureWorks: Select data from first column that has a nonnull value

**14 November, 2022**

SQL AdventureWorks: Calculate row numbers for rows between 50 to 60 inclusive

SQL AdventureWorks: Return first and last name, and other columns using partition by clause

SQL AdventureWorks: Order the result set by the column TerritoryName using CASE

SQL AdventureWorks: Return the highest hourly wage for each job title

SQL AdventureWorks: Sort the BusinessEntityID in descending or ascending order

**13 November, 2022**

SQL AdventureWorks: Return the top ten employees ranked by their salary

SQL AdventureWorks: Divide rows into defined groups based on SalesYTD

SQL AdventureWorks: Rank the products in inventory according to their quantities

SQL AdventureWorks: Find the salary of top ten employees

SQL AdventureWorks: Calculate a row number based on SalesYTD ranking

**12 November, 2022**

C++: Check first string contains letters from the second

C++: Remove a word from a given string

C++: Reverse the words in a string that have odd lengths

C++: Check two consecutive, identical letters in a word

C++: Count occurrences of a certain character in a string

C++: Remove a specific character from a given string

**11 November, 2022**

JavaScript: Check if kth bit is set or not for a number

JavaScript: position of the said binary format

JavaScript: Parity of a given number

JavaScript: Find the non-repeated element from an array

JavaScript: Maximum, minimum of two integers

**10 November, 2022**

JavaScript: Check a number is a power of 4 or not

JavaScript: Swap two bits at given position in an integer

JavaScript: Binary logarithm using bitwise operators

JavaScript: Turn off the kth bit of a given number

JavaScript: Turn on the kth bit of a given number

**09 November, 2022**

JavaScript: Check two integers have opposite signs or not

JavaScript: Swap two variables using bit manipulation

JavaScript: Number of 0 bits in a binary representation

JavaScript: Next power of two of a given number

JavaScript: Odd or even number using bit manipulation

**08 November, 2022**

SQL AdventureWorks: Add two days to each value in the OrderDate column

SQL AdventureWorks: Get a newdate by adding two days with current date

SQL AdventureWorks: Get the differences between the maximum and minimum orderdate

SQL AdventureWorks: Rank the products by the specified inventory locations

**07 November, 2022**

JavaScript: Check if a date is between two other dates

JavaScript: Check if a given date is weekday, weekend

JavaScript: Create and print a calendar

JavaScript: Identify a day based on a date

**06 November, 2022**

JavaScript: Index position of a word within a string

JavaScript: Linear search algorithm

JavaScript: Ternary search algorithm

JavaScript: Jump search algorithm

JavaScript: Interpolation algorithm

**05 November, 2022**

SQL AdventureWorks: Find different sales quotas for a employee over next years

SQL AdventureWorks: Compare year-to-date sales between employees for specific terrotery

SQL AdventureWorks: Find the differences in sales quota for the next quarters

SQL AdventureWorks: Obtain the salary percentile of each employee for a department

**04 November, 2022**

SQL AdventureWorks: Compare year-to-date sales between employees

SQL AdventureWorks: Fetch hiredate of last employee in a department for a salary

SQL AdventureWorks: Find the statistical variance of the sales quota for each quarter

**03 November, 2022**

SQL AdventureWorks: Return the name of the product that is the least expensive

SQL AdventureWorks: Return the employee with the fewest number of vacation hours

**02 November, 2022**

SQL AdventureWorks: Find the departments that each have more than 15 employees

SQL AdventureWorks: Find the total products ordered in each specified orders

SQL AdventureWorks: Compute the variance of sales quota for each quarter in a year

SQL AdventureWorks: Populate the variance of all unique values and all values

SQL AdventureWorks: Find total ListPrice and StandardCost of products of distinct color

SQL AdventureWorks: Find the TotalSalesYTD of each SalesQuota

SQL AdventureWorks: Find the sum of the ListPrice and StandardCost for each color

JavaScript: Check a string for palindromes using recursion

JavaScript: Convert Binary to Decimal using recursion

JavaScript: Binary Search Algorithm using recursion

JavaScript: Letter combinations of a number

**01 November, 2022**

JavaScript: Rearrange a string to become a palindrome

JavaScript: Find the most frequent character in a string