Канал: Anoop Kumar

products which are selling for more than 3000 and append expression based on condition

products which are selling for more than 3000 and append expression based on condition

Python Data cleaning,Change Data type

Python Data cleaning,Change Data type

Guestimate - Number of laptops sold in Bengaluru city every day

Guestimate - Number of laptops sold in Bengaluru city every day

Guestimate- Number of Red cars in Bengaluru

Guestimate- Number of Red cars in Bengaluru

Guestimate -Numer of petrol pumps in Bengaluru city

Guestimate -Numer of petrol pumps in Bengaluru city

Guestimate- Number of washing machine sold every year in india

Guestimate- Number of washing machine sold every year in india

Number of flights in Indian atmosphere currently

Number of flights in Indian atmosphere currently

Guestimate- Total tea consumers in India

Guestimate- Total tea consumers in India

Guestimate- Number of Electric Cars in India

Guestimate- Number of Electric Cars in India

Total Number of Metro pillars in Delhi metro Guestimates

Total Number of Metro pillars in Delhi metro Guestimates

Google Analytics

Google Analytics

Excel WorkDay and WorkDay INTL function

Excel WorkDay and WorkDay INTL function

SQL CTE With Example

SQL CTE With Example

SQL Like Operator

SQL Like Operator

Dense Rank vs Rank

Dense Rank vs Rank

SQL Query On Joins

SQL Query On Joins

SQL Query based on Sub Query and Ranking functions

SQL Query based on Sub Query and Ranking functions

Excel Interview Questions

Excel Interview Questions

Excel Text Functions

Excel Text Functions

Excel SumIF,CountIF, and AverageIF functions

Excel SumIF,CountIF, and AverageIF functions

Excel SumIF,CountIF, and AverageIF functions

Excel SumIF,CountIF, and AverageIF functions

Excel Date Functions

Excel Date Functions

Excel AND function

Excel AND function

Excel Hlookup function

Excel Hlookup function

Excel Index Match Function

Excel Index Match Function

Excel Vlookup function

Excel Vlookup function

Monthly report of new customers

Monthly report of new customers

SQL Rank function

SQL Rank function

Best Supplier of Company

Best Supplier of Company

SubQuery with Example

SubQuery with Example

DENSE_RANK SQL window functions with Example | Advance SQL

DENSE_RANK SQL window functions with Example | Advance SQL

Most expensive order of each customer

Most expensive order of each customer

SQL DENSE RANK Query

SQL DENSE RANK Query

Department-wise Salary Except Top Salary of each department | SQL Window Functions

Department-wise Salary Except Top Salary of each department | SQL Window Functions

Placements Hackerrank SQL Query Solution | Hackerrank SQL Query Solutions

Placements Hackerrank SQL Query Solution | Hackerrank SQL Query Solutions

Top competitors SQL Hackerrank Query Solution | SQL Hackerrank Solutions

Top competitors SQL Hackerrank Query Solution | SQL Hackerrank Solutions

Binary Tree Nodes Hackerrank SQL Query Solution | SQL Hackerrank solutions.

Binary Tree Nodes Hackerrank SQL Query Solution | SQL Hackerrank solutions.

The Report SQL Hackerrank Query Solution | SQL Hackerrank Solutions

The Report SQL Hackerrank Query Solution | SQL Hackerrank Solutions

SQL Hackerrank query solutions | SQL Hackerrank The Pads Query Solution

SQL Hackerrank query solutions | SQL Hackerrank The Pads Query Solution

SQL HackerRank Solutions | Hackerrank New Companies query

SQL HackerRank Solutions | Hackerrank New Companies query

SQL Hackerrank Solutions | Hackerrank New Companies

SQL Hackerrank Solutions | Hackerrank New Companies

SQL Hackerrank Solutions | Occupations Query Solutions

SQL Hackerrank Solutions | Occupations Query Solutions

Learn SQL Views with examples

Learn SQL Views with examples

SQL Project planning | SQL Hackerrank Soutions

SQL Project planning | SQL Hackerrank Soutions

SQL pivot function with example.

SQL pivot function with example.

SQL Joins Explanation with examples.

SQL Joins Explanation with examples.

SQL Zoo(More Join operations) Query Solution, Lead actor in Julie Andrews movies

SQL Zoo(More Join operations) Query Solution, Lead actor in Julie Andrews movies

SQL Rank Function with Example

SQL Rank Function with Example

SQL Query on wildcard and window functions with SQL joins

SQL Query on wildcard and window functions with SQL joins

SQL Query, Find Unique records from data.

SQL Query, Find Unique records from data.

SQL Query ,Find in which month maximum number of students registered in a Course

SQL Query ,Find in which month maximum number of students registered in a Course

SQL Query,Find Second heighest salary

SQL Query,Find Second heighest salary

SQL Query, Find some top customers of a company.

SQL Query, Find some top customers of a company.

Find customers who ordered more than once with the help of SQL functions.

Find customers who ordered more than once with the help of SQL functions.

Find customers who have ordered only once in the 6 months tenure.Use SQL functions

Find customers who have ordered only once in the 6 months tenure.Use SQL functions

Top 4 best-selling products of a company

Top 4 best-selling products of a company

SQL window functions with joins

SQL window functions with joins

Find the highest salary in each department in SQL

Find the highest salary in each department in SQL

count of customers enrolled with the company each month in SQL

count of customers enrolled with the company each month in SQL

SQL Inner join and SQL Aggregate functions with a business problem

SQL Inner join and SQL Aggregate functions with a business problem

Cumulative Sum OR Running Total of Data in SQL

Cumulative Sum OR Running Total of Data in SQL

Dense Rank SQL function with Example

Dense Rank SQL function with Example

Use of SQL Dynamic Variable

Use of SQL Dynamic Variable

SQL Query 8

SQL Query 8

SQL Query 6

SQL Query 6

SQL Query 5

SQL Query 5

SQL Query 4

SQL Query 4

SQL Query 3

SQL Query 3

SQL Query 2

SQL Query 2

Solve SQL Query with WildCard

Solve SQL Query with WildCard