SQL Interview Question By A Startup | Normal vs Mentos Life 😎 скачать в хорошем качестве

SQL Interview Question By A Startup | Normal vs Mentos Life 😎

In this video we will discuss an SQL interview online assess emnt question asked by an startup Vyapar. High quality data analytics and engineering content: https://www.namastesql.com/ scripts: -- Create tables CREATE TABLE department ( dep_id INT, dep_name VARCHAR(50) ); CREATE TABLE empdetails ( emp_id INT, first_name VARCHAR(50), gender VARCHAR(1), dep_id INT ); CREATE TABLE client ( client_id INT, client_name VARCHAR(50) ); CREATE TABLE empsales ( emp_id INT, client_id INT, sales INT ); -- Insert data INSERT INTO department (dep_id, dep_name) VALUES (1, 'Electronics'), (2, 'Furniture'), (3, 'Clothing'); INSERT INTO empdetails (emp_id, first_name, gender, dep_id) VALUES (101, 'Alice', 'F', 1), (102, 'Bob', 'M', 1), (103, 'Charlie', 'M', 2), (104, 'Diana', 'F', 2), (105, 'Ethan', 'M', 3), (106, 'Fiona', 'F', 3); INSERT INTO client (client_id, client_name) VALUES (1, 'Amazon'), (2, 'Walmart'), (3, 'Costco'), (4, 'Target'), (5, 'BestBuy'); INSERT INTO empsales (emp_id, client_id, sales) VALUES (101, 1, 5000), (101, 2, 3000), (102, 1, 7000), (102, 3, 2000), (103, 2, 4000), (103, 4, 3000), (104, 4, 6000), (105, 5, 8000), (106, 3, 5000), (106, 5, 2000); Zero to hero(Advance) SQL Aggregation:    • All About SQL Aggregations | SQL Advance |...   Most Asked Join Based Interview Question:    • Most Asked SQL JOIN based Interview Questi...   Solving 4 Trick SQL problems:    • Solving 4 Tricky SQL Problems   Data Analyst Spotify Case Study:    • Data Analyst Spotify Case Study | SQL Inte...   Top 10 SQL interview Questions:    • Top 10 SQL interview Questions and Answers...   Interview Question based on FULL OUTER JOIN:    • SQL Interview Question Based on Full Outer...   Playlist to master SQL :    • Complex SQL Questions for Interview Prepar...   Rank, Dense_Rank and Row_Number:    • RANK, DENSE_RANK, ROW_NUMBER SQL Analytica...   #sql #dataengineer