SQL Natural Join
What is SQL Natural Join? Natual Join is a type of join in SQL which combines row from 2 tables based on common column which has same name and datatype. …
sql interview questions
Display the cumulative percentage of total sales for each product.
This question was asked in Interview at black rock. Read more Company: BlackRock CTC: 26LPA Source: LinkedIn SQL Interview Question Q. Display the cumulative percentage of total sales for each …
Write a query to group employees by age ranges (e.g., 20–30, 31–40) and count the number of employees in each group.
This question was asked in Interview at black rock. read more Company: BlackRock CTC: 26LPA SQL Interview Question Question Q. Write a query to group employees by age ranges (e.g., …
Running Total for Different Genders: Write an SQL query to find the total score for each gender at each day
This question was asked in Facebook interview, Ask is to provide Running Total for Different Genders. Source: LeetCode Difficulty: Medium Company: Facebook Running Total for Different Genders Q. Write an …
Page Recommendations: Write an SQL query to recommend pages to the user
This question was asked in Facebook interview, Ask is to give page recommendation for user1 based on Friendship and Likes. Source: LeetCode Difficulty: Medium Company: Facebook Page Recommendations Q. Write …