💻 Quiz Challenge
Let’s see how good are you when it comes to SQL!
Check out the employee data in the comment section below, and answer the quiz question.
Following are various SQL queries when written can extract data from the employee details table:
A. SELECT * FROM employee e LEFT JOIN employee_personal_detail epd ON e.id = epd.employee_id
B. SELECT * FROM employee e JOIN employee_personal_detail epd ON e.created_at = epd.created_at
C. SELECT * FROM employee e LEFT JOIN employee_personal_detail epd ON e.created_at = epd.created_at
D. SELECT * FROM employee e JOIN employee_personal_detail epd ON e.id = epd.employee_id
Which among the above SQL queries will be able to extract all the data of all the employees who joined in the month of February 2023?
Option A
Option B
Option C
Option D
Options A & D
Options C & B
None of the above
👉 The answer that is correct with the best explanation will be rewarded with a cash prize of INR 500!!
P.S. Give your answers in the comment section below. The best comment will be pinned. 📌

6 likes