SQL Interview Questions !!

🎗 Write a query to find all employees whose salaries exceed the company's average salary.
🎗 Write a query to retrieve the names of employees who work in the same department as 'John Doe'.
🎗 Write a query to display the second highest salary from the Employee table without using the MAX function twice.
🎗 Write a query to find all customers who have placed more than five orders.
🎗 Write a query to count the total number of orders placed by each customer.
🎗 Write a query to list employees who joined the company within the last 6 months.
🎗 Write a query to calculate the total sales amount for each product.
🎗 Write a query to list all products that have never been sold.
🎗 Write a query to remove duplicate rows from a table.
🎗 Write a query to identify the top 10 customers who have not placed any orders in the past year.



Like this post if you need more 👍❤️

Hope it helps :)

1️⃣5️⃣ Chrome Extensions I wish I knew earlier as a CS student >

1. Dark Reader - Turn any website into dark mode for comfortable late-night coding.

2. Grammarly - Fix grammar & spelling mistakes instantly in emails, docs, and chats.

3. Picture-in-Picture - Watch lectures or tutorials while coding in another tab.

4. Tab Wrangler - Auto-close inactive tabs and keep your browser fast.

5. ColorZilla - Pick colors from any webpage for your design projects.

6. Momentum - Replace the boring new tab with an aesthetic focus dashboard.

7. WhatFont - Instantly detect fonts used on any website.

8. Loom - Record your screen + camera for presentations or explaining code.

9. Auto Tab Discard - Save RAM by pausing unused tabs automatically.

10. Code Copy - Copy code snippets from any site without annoying formatting.

11. Google Dictionary - Double-click any word to get its meaning instantly.

12. StayFocusd - Block distracting sites and focus on your work.

13. Nimbus Screenshot - Take full-page screenshots and annotate them.

14. Mote - Record quick voice notes and add them to Docs, Slides, or Gmail.

15. Language Tool - Grammarly alternative with multi-language support.👉🏻💪⛳️