Learning, Free job alert & More
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. It automatically matches the 2 columns and eliminates the duplicate column. read more Example Database CustomerID FirstName LastName Email City 1 John Doe [email protected] New … Read more
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., 20–30, 31–40) and count the number of employees in each group. Solution age-range num_employee 21-30 7 31-40 6 41-50 5 51-60 2 View on DB … Read more
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 SQL query to find the total score for each gender at each day. Order the result table by gender and day. Solution Explanation The solution … Read more
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 an SQL query to recommend pages to the user with user_id = 1 using the pages that your friends liked. It should not recommend pages you already liked. … Read more
Data Analyst Recruitment In Qualcomm : Explore exciting Data Analyst job openings at Qualcomm in Hyderabad, Telangana, India. Join the People Analytics team and leverage your experience in data analytics to create impactful BI products and dashboards. Qualcomm seeks an experienced Data Analyst who can thrive in a collaborative environment and contribute to innovative solutions. Don’t miss the chance to search open positions and embark on … Read more