FAANG Task#11 - Employee Bonus | LEET CODE | SQL Challenge | Tuitions Tonight

Опубликовано: 30 Октябрь 2024
на канале: Tuitions Tonight
196
2

Please support us on Patreon to grow   / tonightstonight  

JOIN our WhatsApp "Tuitions Tonight family": https://chat.whatsapp.com/L3lgd6u2BhV...

If you want help creating a project click here:   / tuitionstonight  

In this video, I will show you how to solve the SQL Challenge Task 11 | LEETCODE | Tuitions Tonight

Table: Employee

+-------------+---------+
| Column Name | Type |
+-------------+---------+
| empId | int |
| name | varchar |
| supervisor | int |
| salary | int |
+-------------+---------+

empId is the column with unique values for this table.
Each row of this table indicates the name and the ID of an employee in addition to their salary and the ID of their manager.


Table: Bonus

+-------------+------+
| Column Name | Type |
+-------------+------+
| empId | int |
| bonus | int |
+-------------+------+
empId is the column of unique values for this table.
empId is a foreign key (reference column) to empId from the Employee table.
Each row of this table contains the id of an employee and their respective bonus.


Write a solution to report the name and bonus amount of each employee with a bonus less than 1000.

Return the result table in any order.

The result format is in the following example.



Source Code: https://tuitionstonight.com/


Read Some Useful Articles here on our Website https://tuitionstonight.com

Complete Roadmap on How to Become Data Scientist in 3 Months?
https://tuitionstonight.com/roadmap-t...

Complete Roadmap on How to Become Data Analyst in 2 Months?

https://tuitionstonight.com/roadmap-t...


Complete Roadmap on How to Become Data Engineer in 3 Months?

https://tuitionstonight.com/roadmap-t...

Complete Roadmap on How to Become DevOps Engineer in 3 Months?

https://tuitionstonight.com/complete-...
------------------------------------------------------------------------------------------
🌓 FOR CONNECTION OF APACHE NETBEANS WITH MYSQL DBMS ⇙
➡️    • How to connect JDBC -  Java App with ...   ⇠ ⇠ ⇠

FOR MORE JAVA AND MYSQL PROJECTS
🔴Banking System using JAVA and MYSQL DBMS
➡️    • How to Create Banking System using JS...  

🔴School Management System using JAVA integrated with MYSQL Database
➡️    • Complete School Management System int...  

🔴Hospital Management System using JAVA integrated with MYSQL Database
➡️    • Complete Hospital Management System u...  

🔴CAKE SHOP MANAGEMENT System using JAVA and MYSQL DBMS
➡️    • Video  

------------------------------------------------------------------------------------------
FOR SIMPLE JAVA SWINGS PROJECTS [WITHOUT DBMS]
🔴ACCOUNTING SYSTEM
➡️   • How to create Accounting Software in ...  

🔴SCHOOL MANAGEMENT SYSTEM
➡️   • How to create School Management Softw...  

🔴HOSPITAL MANAGEMENT SYSTEM
➡️   • How to make Hospital Management syste...  

🔴LIBRARY MANAGEMENT SYSTEM
➡️   • How to make Library Management System...  

------------------------------------------------------------------------------------------
© Credit of Music goes to:
------------------------------------------------------------------------------------------
🔴For Promotions and Collaborations:
Email Us: [email protected]
-------------------------------------------------------------------------------------------
🔥Visit our Website to see interesting articles🔥
https://tuitionstonight.com/
🔥𝙁𝙤𝙡𝙡𝙤𝙬 𝙪𝙨 𝙊𝙣 𝙎𝙤𝙘𝙞𝙖𝙡 𝙢𝙚𝙙𝙞𝙖 𝙛𝙤𝙧 𝙙𝙖𝙞𝙡𝙮 𝙛𝙚𝙚𝙙𝙨🔥
Instagram:   / tuitionstonight  
Instagram:   / muhammad_taha_azam  
Facebook: https://www.facebook.com/TT7.in/?moda...
------------------------------------------------------------------------------------------

Like, Subscribe & share
Support our Channel
Tuitions Tonight
https://tuitionstonight.com/
[email protected]