SQL Interview Questions which can be asked in a Data Analyst Interview.
1️⃣ What is difference between Primary key and Unique key?
◼️Primary key- A column or set of columns which uniquely identifies each record in a table. It can't contain null values and only one primary key
can exist in a table.
◼️Unique key-Similar to primary key it also uniquely identifies each record in a table and can contain null values.Multiple Unique key can exist in a table.
2️⃣ What is a Candidate key?
◼️A key or set of keys that uniquely identifies each record in a table.It is a combination of Primary and Alternate key.
3️⃣ What is a Constraint?
◼️Specific rule or limit that we define in our table. E.g - NOT NULL,AUTO INCREMENT
4️⃣ Can you differentiate between TRUNCATE and DELETE?
◼️TRUNCATE is a DDL command. It deletes the entire data from a table but preserves the structure of table.It doesn't deletes the data row by row hence faster than DELETE command, while DELETE is a DML command and it deletes the entire data based on specified condition else deletes the entire data,also it deletes the data row by row hence slower than TRUNCATE command.
5️⃣ What is difference between 'View' and 'Stored Procedure'?
◼️A View is a virtual table that gets data from the base table .It is basically a Select statement,while Stored Procedure is a sql statement or set of sql statement stored on database server.
6️⃣ What is difference between a Common Table Expression and temporary table?
◼️CTE is a temporary result set that is defined within execution scope of a single SELECT ,DELETE,UPDATE statement while temporary table is stored in TempDB and gets deleted once the session expires.
7️⃣ Differentiate between a clustered index and a non-clustered index?
◼️ A clustered index determines physical ordering of data in a table and a table can have only one clustered index while a non-clustered index is analogous to index of a book where index is stored at one place and data at other place and index will have pointers to storage location of the data,a table can have more than one non-clustered index.
8️⃣ Explain triggers ?
◼️They are sql codes which are automatically executed in response to certain events on a table.They are used to maintain integrity of data.
Here you can find essential SQL Interview Resources👇
https://topmate.io/learning_resources/1456762
Like this post if you need more 👍❤️
Hope it helps :)
Follow This WhatsApp Channel for More Resources:
https://whatsapp.com/channel/0029VahGttK5a24AXAJDjm2R
1️⃣ What is difference between Primary key and Unique key?
◼️Primary key- A column or set of columns which uniquely identifies each record in a table. It can't contain null values and only one primary key
can exist in a table.
◼️Unique key-Similar to primary key it also uniquely identifies each record in a table and can contain null values.Multiple Unique key can exist in a table.
2️⃣ What is a Candidate key?
◼️A key or set of keys that uniquely identifies each record in a table.It is a combination of Primary and Alternate key.
3️⃣ What is a Constraint?
◼️Specific rule or limit that we define in our table. E.g - NOT NULL,AUTO INCREMENT
4️⃣ Can you differentiate between TRUNCATE and DELETE?
◼️TRUNCATE is a DDL command. It deletes the entire data from a table but preserves the structure of table.It doesn't deletes the data row by row hence faster than DELETE command, while DELETE is a DML command and it deletes the entire data based on specified condition else deletes the entire data,also it deletes the data row by row hence slower than TRUNCATE command.
5️⃣ What is difference between 'View' and 'Stored Procedure'?
◼️A View is a virtual table that gets data from the base table .It is basically a Select statement,while Stored Procedure is a sql statement or set of sql statement stored on database server.
6️⃣ What is difference between a Common Table Expression and temporary table?
◼️CTE is a temporary result set that is defined within execution scope of a single SELECT ,DELETE,UPDATE statement while temporary table is stored in TempDB and gets deleted once the session expires.
7️⃣ Differentiate between a clustered index and a non-clustered index?
◼️ A clustered index determines physical ordering of data in a table and a table can have only one clustered index while a non-clustered index is analogous to index of a book where index is stored at one place and data at other place and index will have pointers to storage location of the data,a table can have more than one non-clustered index.
8️⃣ Explain triggers ?
◼️They are sql codes which are automatically executed in response to certain events on a table.They are used to maintain integrity of data.
Here you can find essential SQL Interview Resources👇
https://topmate.io/learning_resources/1456762
Like this post if you need more 👍❤️
Hope it helps :)
Follow This WhatsApp Channel for More Resources:
https://whatsapp.com/channel/0029VahGttK5a24AXAJDjm2R
Boost your SQL skills with these exciting challenges:
1️⃣ List salesmen and customers from the same city.
2️⃣ Fetch order details for amounts between $500 and $2000.
3️⃣ Identify salesmen working with specific customers.
4️⃣ Find customers whose salesmen earn over 12% commission.
5️⃣ List customers with salesmen in different cities earning more than 12%.
6️⃣ Retrieve complete order details, including salesman commissions.
7️⃣ Join Salesman, Customer, and Order tables for unique insights.
8️⃣ Identify customers with or without assigned salesmen.
9️⃣ Retrieve low-grade customers working independently or with salesmen.
🔟 Report customers placing multiple orders.
SQL Mindmap👇
https://t.me/sqlresourcestp/13
Like this post if you need more 👍❤️
Hope it helps :)
Follow This WhatsApp Channel for More Resources:
https://whatsapp.com/channel/0029VahGttK5a24AXAJDjm2R
1️⃣ List salesmen and customers from the same city.
2️⃣ Fetch order details for amounts between $500 and $2000.
3️⃣ Identify salesmen working with specific customers.
4️⃣ Find customers whose salesmen earn over 12% commission.
5️⃣ List customers with salesmen in different cities earning more than 12%.
6️⃣ Retrieve complete order details, including salesman commissions.
7️⃣ Join Salesman, Customer, and Order tables for unique insights.
8️⃣ Identify customers with or without assigned salesmen.
9️⃣ Retrieve low-grade customers working independently or with salesmen.
🔟 Report customers placing multiple orders.
SQL Mindmap👇
https://t.me/sqlresourcestp/13
Like this post if you need more 👍❤️
Hope it helps :)
Follow This WhatsApp Channel for More Resources:
https://whatsapp.com/channel/0029VahGttK5a24AXAJDjm2R
GLBC in UK is Inviting Applications For: 2025 Global Leadership & Business Certification, Cambridge
- Type: Training
- Location: Clare College, Cambridge
- Duration: 5 Days
- Eligible Countries : All
- Deadline: 18th April, 2025
Funding Type:
- Fully
- Partial and
- Self Funded
Benefits:
- Air ticket
- Accommodation
- Certificate
- Conference kits, etc
Grab the Fully Funded seat on time because the seat is limited!
Apply here:
https://kenyatrends.co.ke/glbc-in-uk-is-inviting-applications-for-2025-global-leadership-business-certification-cambridge
- Type: Training
- Location: Clare College, Cambridge
- Duration: 5 Days
- Eligible Countries : All
- Deadline: 18th April, 2025
Funding Type:
- Fully
- Partial and
- Self Funded
Benefits:
- Air ticket
- Accommodation
- Certificate
- Conference kits, etc
Grab the Fully Funded seat on time because the seat is limited!
Apply here:
https://kenyatrends.co.ke/glbc-in-uk-is-inviting-applications-for-2025-global-leadership-business-certification-cambridge
KenyaTrends.co.ke
Kenya Trends - Jobs | Opportunities | Free Resources
Sharing free learning resources, jobs & opportunities.
👍1
ScholarshipYork University Graduate Scholarships for International Students (2025/2026)
York University, Canada is offering various scholarships for international students.
1. International Entrance Scholarships ($20k - $45k per year)
2. York Science Scholars Award ($10,000)
3. Ontario Graduate Scholarship ($15,000 per year)
4. International Student Emergency Bursary
How to Apply:
https://kenyatrends.co.ke/york-university-graduate-scholarships-for-international-students-2025-2026/
Share with Your Friends ❤️
KenyaTrends.co.ke
Kenya Trends - Jobs | Opportunities | Free Resources
Sharing free learning resources, jobs & opportunities.
Free Online courses with certificate from Microsoft
Python for beginners
https://learn.microsoft.com/en-us/training/paths/beginner-python/
Get started with Azure Cosmos DB for NoSQL
https://learn.microsoft.com/en-us/training/paths/get-started-azure-cosmos-db-sql-api/
Introduction to machine learning with Python and Azure Notebooks
https://learn.microsoft.com/en-us/training/paths/intro-to-ml-with-python/
Automate development tasks by using GitHub Actions
https://bit.ly/48E75xT
SQL, Power BI & AI Fundamentals
https://tinyurl.com/bdcsnxmf
Write your first code using C#
https://learn.microsoft.com/en-us/training/paths/get-started-c-sharp-part-1/
Join for more free resources
https://t.me/techpsyche
ENJOY LEARNING 👍👍
Follow This WhatsApp Channel for More Resources:
https://whatsapp.com/channel/0029VahGttK5a24AXAJDjm2R
Python for beginners
https://learn.microsoft.com/en-us/training/paths/beginner-python/
Get started with Azure Cosmos DB for NoSQL
https://learn.microsoft.com/en-us/training/paths/get-started-azure-cosmos-db-sql-api/
Introduction to machine learning with Python and Azure Notebooks
https://learn.microsoft.com/en-us/training/paths/intro-to-ml-with-python/
Automate development tasks by using GitHub Actions
https://bit.ly/48E75xT
SQL, Power BI & AI Fundamentals
https://tinyurl.com/bdcsnxmf
Write your first code using C#
https://learn.microsoft.com/en-us/training/paths/get-started-c-sharp-part-1/
Join for more free resources
https://t.me/techpsyche
ENJOY LEARNING 👍👍
Follow This WhatsApp Channel for More Resources:
https://whatsapp.com/channel/0029VahGttK5a24AXAJDjm2R
𝐔𝐩𝐬𝐤𝐢𝐥𝐥 𝐲𝐨𝐮𝐫𝐬𝐞𝐥𝐟 𝐰𝐢𝐭𝐡 𝐭𝐡𝐞𝐬𝐞 𝟑 𝐦𝐮𝐬𝐭-𝐝𝐨 𝐟𝐫𝐞𝐞 𝐃𝐚𝐭𝐚 𝐀𝐧𝐚𝐥𝐲𝐭𝐢𝐜𝐬 𝐜𝐨𝐮𝐫𝐬𝐞𝐬! 📊
1️⃣ Data Analytics Essentials by Cisco - Learn the fundamentals.
2️⃣ Google Data Analytics Professional - Access it for FREE using this ChatGPT prompt: 'Write a financial aid for me to apply on Coursera’s Google Data Analytics Professional course considering that I am a student who does not earn yet.'
3️⃣ Complete Power BI Course by Microsoft - Master data visualization!
𝐋𝐢𝐧𝐤👇:-
https://tinyurl.com/m239d2s8
Enroll For FREE & Get Certified 🎓
1️⃣ Data Analytics Essentials by Cisco - Learn the fundamentals.
2️⃣ Google Data Analytics Professional - Access it for FREE using this ChatGPT prompt: 'Write a financial aid for me to apply on Coursera’s Google Data Analytics Professional course considering that I am a student who does not earn yet.'
3️⃣ Complete Power BI Course by Microsoft - Master data visualization!
𝐋𝐢𝐧𝐤👇:-
https://tinyurl.com/m239d2s8
Enroll For FREE & Get Certified 🎓
If you are interested to learn SQL for data analytics purpose and clear the interviews, just cover the following topics 📚
1. Install MYSQL workbench 💻
2. Select 📈
3. From 📁
4. where 🔍
5. group by 📊
6. having 🔍
7. limit 📈
8. Joins (Left, right , inner, self, cross) 🤝
9. Aggregate function ( Sum, Max, Min , Avg) 📊
10. windows function ( row num, rank, dense rank, lead, lag, Sum () over) 🔍
11. Case 🤔
12. Like 🔍
13. Sub queries 📊
14. CTE 📁
15. Replace CTE with temp tables 🔄
16. Methods to optimize Sql queries 🚀
17. Solve problems and case studies
Trick: Just copy each term and paste on youtube and watch any 10 to 15 minute on each topic and practise it while learning , By doing this , you get the basics understanding 📚
18. Now time to go on youtube and search data analysis end to end project using sql 📊
19. Watch them and practise them end to end 📺
20. learn integration with power bi 📈
In this way , you will not only memorize the concepts but also learn how to implement them in your current working and projects and will be able to defend it in your interviews as well 🎉.
Like for more 👍
Here you can find essential resources
👇👇
https://t.me/sqlresourcestp
Hope it helps :) 😊
Follow This WhatsApp Channel for More Resources:
https://whatsapp.com/channel/0029VahGttK5a24AXAJDjm2R
1. Install MYSQL workbench 💻
2. Select 📈
3. From 📁
4. where 🔍
5. group by 📊
6. having 🔍
7. limit 📈
8. Joins (Left, right , inner, self, cross) 🤝
9. Aggregate function ( Sum, Max, Min , Avg) 📊
10. windows function ( row num, rank, dense rank, lead, lag, Sum () over) 🔍
11. Case 🤔
12. Like 🔍
13. Sub queries 📊
14. CTE 📁
15. Replace CTE with temp tables 🔄
16. Methods to optimize Sql queries 🚀
17. Solve problems and case studies
Trick: Just copy each term and paste on youtube and watch any 10 to 15 minute on each topic and practise it while learning , By doing this , you get the basics understanding 📚
18. Now time to go on youtube and search data analysis end to end project using sql 📊
19. Watch them and practise them end to end 📺
20. learn integration with power bi 📈
In this way , you will not only memorize the concepts but also learn how to implement them in your current working and projects and will be able to defend it in your interviews as well 🎉.
Like for more 👍
Here you can find essential resources
👇👇
https://t.me/sqlresourcestp
Hope it helps :) 😊
Follow This WhatsApp Channel for More Resources:
https://whatsapp.com/channel/0029VahGttK5a24AXAJDjm2R
2025 Google Conference Scholarships
Perks:
* Roundtrip airfare
* Conference registration
* $100 stipend
* Hotel accommodation
Criteria:
* Be a full-time student enrolled with a recognized university in Africa OR Asia Pacific(APAC) who is in need of conference travel funds.
* If you're Non-African, also check the provided link for appropriate option.
Apply here:
https://kenyatrends.co.ke/2025-google-conference-scholarships/
Perks:
* Roundtrip airfare
* Conference registration
* $100 stipend
* Hotel accommodation
Criteria:
* Be a full-time student enrolled with a recognized university in Africa OR Asia Pacific(APAC) who is in need of conference travel funds.
* If you're Non-African, also check the provided link for appropriate option.
Apply here:
https://kenyatrends.co.ke/2025-google-conference-scholarships/
Interviewer: "What do you know about our company?"
Candidate: "I think you do something related to tech?"
Big mistake! A vague or uncertain response makes you look unprepared & disinterested. Employers want to see that you’ve taken the time to understand their company & why you’d be a great fit.
What NOT to say:
❌ "I don’t know much, but I’m eager to learn" (shows a lack of preparation)
❌ "I just saw the job posting & applied" (feels random & unintentional)
❌ "It’s a big company, so I thought it’d be a good opportunity" (too generic & uninformed)
How to IMPRESS with your answer:
✔️ Shows research & enthusiasm
"Your company is a leader in [industry/product/service] & I was excited to learn about your recent [mention an achievement, innovation or project]. I really admire your commitment to [company value or mission] & that’s one of the reasons I’m drawn to this opportunity"
✔️ Demonstrates genuine interest
"From what I’ve read, your company stands out for [unique aspect: innovation, company culture, impact]. One thing that caught my attention was [specific initiative or milestone] & I’d love the opportunity to contribute to something similar"
✔️ Aligns your goals with the company’s vision
"I’ve been following your company’s growth & I truly respect how you [mention key values, industry influence, sustainability efforts, etc.]. The way you [specific company approach] aligns with my own professional goals & I’m excited about the potential to be part of your team"
Take a few minutes to research before your interview, check their website, social media, recent news & LinkedIn updates. A well-prepared candidate always stands out!
Candidate: "I think you do something related to tech?"
Big mistake! A vague or uncertain response makes you look unprepared & disinterested. Employers want to see that you’ve taken the time to understand their company & why you’d be a great fit.
What NOT to say:
❌ "I don’t know much, but I’m eager to learn" (shows a lack of preparation)
❌ "I just saw the job posting & applied" (feels random & unintentional)
❌ "It’s a big company, so I thought it’d be a good opportunity" (too generic & uninformed)
How to IMPRESS with your answer:
✔️ Shows research & enthusiasm
"Your company is a leader in [industry/product/service] & I was excited to learn about your recent [mention an achievement, innovation or project]. I really admire your commitment to [company value or mission] & that’s one of the reasons I’m drawn to this opportunity"
✔️ Demonstrates genuine interest
"From what I’ve read, your company stands out for [unique aspect: innovation, company culture, impact]. One thing that caught my attention was [specific initiative or milestone] & I’d love the opportunity to contribute to something similar"
✔️ Aligns your goals with the company’s vision
"I’ve been following your company’s growth & I truly respect how you [mention key values, industry influence, sustainability efforts, etc.]. The way you [specific company approach] aligns with my own professional goals & I’m excited about the potential to be part of your team"
Take a few minutes to research before your interview, check their website, social media, recent news & LinkedIn updates. A well-prepared candidate always stands out!
𝐌𝐢𝐜𝐫𝐨𝐬𝐨𝐟𝐭 𝐅𝐑𝐄𝐄 𝐂𝐞𝐫𝐭𝐢𝐟𝐢𝐜𝐚𝐭𝐢𝐨𝐧 𝐂𝐨𝐮𝐫𝐬𝐞𝐬😍
- Artificial Intelligence (AI)
- Internet Of Things (IoT)
- Machine Learning (ML)
- Data Science
🌟 Globally Recognized Certification
🌟 100% FREE – No Hidden Costs!
🌟 Boost Your Resume & Career
𝐄𝐧𝐫𝐨𝐥𝐥 𝐟𝐨𝐫 𝐅𝐑𝐄𝐄 👇:-
https://bit.ly/3DBGkzk
🎯 Learn. Get Certified. Shine Bright!🎓✨
- Artificial Intelligence (AI)
- Internet Of Things (IoT)
- Machine Learning (ML)
- Data Science
🌟 Globally Recognized Certification
🌟 100% FREE – No Hidden Costs!
🌟 Boost Your Resume & Career
𝐄𝐧𝐫𝐨𝐥𝐥 𝐟𝐨𝐫 𝐅𝐑𝐄𝐄 👇:-
https://bit.ly/3DBGkzk
🎯 Learn. Get Certified. Shine Bright!🎓✨
Quick Recap of Essential SQL Concepts
1️⃣ FROM clause: Specifies the tables from which data will be retrieved.
2️⃣ WHERE clause: Filters rows based on specified conditions.
3️⃣ GROUP BY clause: Groups rows that have the same values into summary rows.
4️⃣ HAVING clause: Filters groups based on specified conditions.
5️⃣ SELECT clause: Specifies the columns to be retrieved.
6️⃣ WINDOW functions: Functions that perform calculations across a set of table rows.
7️⃣ AGGREGATE functions: Functions like COUNT, SUM, AVG that perform calculations on a set of values.
8️⃣ UNION / UNION ALL: Combines the result sets of multiple SELECT statements.
9️⃣ ORDER BY clause: Sorts the result set based on specified columns.
🔟 LIMIT / OFFSET (or FETCH / OFFSET in some databases): Controls the number of rows returned and starting point for retrieval.
Here you can find quick SQL Revision Notes👇
https://t.me/sqlresourcestp
Hope it helps :)
More Resources Here
https://whatsapp.com/channel/0029VahGttK5a24AXAJDjm2R
1️⃣ FROM clause: Specifies the tables from which data will be retrieved.
2️⃣ WHERE clause: Filters rows based on specified conditions.
3️⃣ GROUP BY clause: Groups rows that have the same values into summary rows.
4️⃣ HAVING clause: Filters groups based on specified conditions.
5️⃣ SELECT clause: Specifies the columns to be retrieved.
6️⃣ WINDOW functions: Functions that perform calculations across a set of table rows.
7️⃣ AGGREGATE functions: Functions like COUNT, SUM, AVG that perform calculations on a set of values.
8️⃣ UNION / UNION ALL: Combines the result sets of multiple SELECT statements.
9️⃣ ORDER BY clause: Sorts the result set based on specified columns.
🔟 LIMIT / OFFSET (or FETCH / OFFSET in some databases): Controls the number of rows returned and starting point for retrieval.
Here you can find quick SQL Revision Notes👇
https://t.me/sqlresourcestp
Hope it helps :)
More Resources Here
https://whatsapp.com/channel/0029VahGttK5a24AXAJDjm2R
𝐀𝐫𝐞 𝐲𝐨𝐮 𝐩𝐫𝐞𝐩𝐚𝐫𝐢𝐧𝐠 𝐟𝐨𝐫 𝐒𝐐𝐋 𝐢𝐧𝐭𝐞𝐫𝐯𝐢𝐞𝐰𝐬? 😍
Don’t miss these top SQL questions recently asked by leading companies!
Top 45 SQL Interview Questions & Answers
𝐋𝐢𝐧𝐤👉:- https://bit.ly/4iH0Z3K
Start practicing today and stand out from the competition! 💻
Don’t miss these top SQL questions recently asked by leading companies!
Top 45 SQL Interview Questions & Answers
𝐋𝐢𝐧𝐤👉:- https://bit.ly/4iH0Z3K
Start practicing today and stand out from the competition! 💻
👍1
2 Remote Tech Jobs at Zerion
1. Senior BackEnd Engineer
2. Senior Product Designer
Apply Here:
https://kenyatrends.co.ke/c4pc
1. Senior BackEnd Engineer
2. Senior Product Designer
Apply Here:
https://kenyatrends.co.ke/c4pc
𝐀𝐈 & 𝐌𝐋 𝐅𝐑𝐄𝐄 𝐂𝐞𝐫𝐭𝐢𝐟𝐢𝐜𝐚𝐭𝐢𝐨𝐧 𝐂𝐨𝐮𝐫𝐬𝐞𝐬 𝐅𝐫𝐨𝐦 6 𝐓𝐨𝐩 𝐈𝐧𝐬𝐭𝐢𝐭𝐮𝐭𝐢𝐨𝐧𝐬!😍
Explore these 6 amazing courses offered by the Government of India, Google, Harvard, MIT, and IBM.
Gain hands-on knowledge in Generative AI, Python, Machine Learning, and AI’s impact on business strategy—all at no cost.
Plus, you’ll earn certificates to boost your resume!
𝐋𝐢𝐧𝐤 👇:-
https://bit.ly/4hCdn45
Enroll For FREE & Get Certified 🎓
Explore these 6 amazing courses offered by the Government of India, Google, Harvard, MIT, and IBM.
Gain hands-on knowledge in Generative AI, Python, Machine Learning, and AI’s impact on business strategy—all at no cost.
Plus, you’ll earn certificates to boost your resume!
𝐋𝐢𝐧𝐤 👇:-
https://bit.ly/4hCdn45
Enroll For FREE & Get Certified 🎓
Forwarded from Artificial Intelligence Resources TP . AI Tools . AI Updates
𝐆𝐨𝐨𝐠𝐥𝐞 𝐅𝐑𝐄𝐄 𝐀𝐈/𝐌𝐋 𝐂𝐞𝐫𝐭𝐢𝐟𝐢𝐜𝐚𝐭𝐢𝐨𝐧 𝐂𝐨𝐮𝐫𝐬𝐞
Unlock the world of AI/ML with Google’s completely free course series!
Learn everything from the basics of machine learning to advanced AI applications, guided by experts at Google.
𝐋𝐢𝐧𝐤👇 :-
https://tinyurl.com/53bpvmkc
Enroll For FREE & Get Certified🎓
Unlock the world of AI/ML with Google’s completely free course series!
Learn everything from the basics of machine learning to advanced AI applications, guided by experts at Google.
𝐋𝐢𝐧𝐤👇 :-
https://tinyurl.com/53bpvmkc
Enroll For FREE & Get Certified🎓
❤1
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.
Here you can find essential SQL Interview Resources👇
https://t.me/sqlresourcestp/40
Like this post if you need more 👍❤️
Hope it helps :)
More Resources Here
https://whatsapp.com/channel/0029VahGttK5a24AXAJDjm2R
🎗 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.
Here you can find essential SQL Interview Resources👇
https://t.me/sqlresourcestp/40
Like this post if you need more 👍❤️
Hope it helps :)
More Resources Here
https://whatsapp.com/channel/0029VahGttK5a24AXAJDjm2R