Все публикации

What % of total salary is given to each employee. #sql #sqlinterviewquestions #sqlinterview

Merge/join 2 pandas dataframes. #pandasdataframe #pythonpandas #pythonprogramming

Add column in df by extracting values from dictionary #pandas #pythonpandas #pythonprogramming

add new column in pandas df based on existing column values. #pandas #python #pythonpandas

SQL query to find income per product. #sql #sqlinterviewquestions #sqlinterview

add a new column to pandas df with static value. #pythonpandas #python #pythonprogramming #pandas

create pandas dataframe from python dictionary. #pythonpandas #python #pythonprogramming

create pandas dataframe from python list. #pythonpandas #python #pythonprogramming #pandasdataframe

SQL query to find cities that contains character o. #sql #sqlinterviewquestions

sql query to find cities with 2nd char as a. #sql #sqlinterviewquestions

SQL query to find firstname from fullname. #sql #sqlinterviewquestions

create spark dataframe from CSV. #apachespark

create spark dataframe from seq. #apachespark

find number of customers with same number of orders.#sql #sqlinterviewquestions

find customers who placed more than 5 orders #sql #sqlinterviewquestions

Find employees earning 3rd highest salaries in their departments. #sql #sqlinterviewquestions

row_number, rank and dense_rank in SQL #sql #sqlinterviewquestions #sqlinterview

SQL query to find customer who did not order anything. #sql #sqlinterviewquestions #sqlinterview

Get products of category that has highest no. of products. #sql #sqlinterviewquestions #sqlinterview

SQL query to find product having 2nd highest price. #sql #sqlinterview #sqlinterviewquestions

SQL DELETE Statement | Deleting records from a table | Deleting specific records from a table

SQL UPDATE Statement | Update values of columns for specific records and all records

SQL query to find products with price more than avg price. #sql #sqlinterviewquestions #sqlinterview

SQL query to find total income per product. #sql #sqlinterviewquestions #sqlinterview #sqljoins