Welcoem to posts!!
in the future - u will be able to do some more stuff here,,,!! like pat catgirl- i mean um yeah... for now u can only see others's posts :c
🚀 New Article Alert: How do you handle Recursive Queries in SQL?
Published an article on Medium explaining Recursive Common Table Expressions (CTE)—perfect for anyone looking to work with hierarchical data in SQL.
🔗 Read it here: medium.com/@vishnutrvishnutr/how-do-you-handle-rec…
#SQL #DataAnalytics #RecursiveCTE #SQLQueries
2 - 0
#SQL Challenge✅
What will be the output of the following queries ?
1️⃣SELECT CONCAT('SQL', NULL, 'Challenge');
2️⃣SELECT CASE
WHEN 5 > 3 THEN 'True'
WHEN 5 < 3 THEN 'False'
ELSE 'Unknown'
END;
3️⃣SELECT NULLIF(5, 5), NULLIF(5, 3);
4️⃣SELECT FLOOR(3.999), CEILING(3.001), ROUND(3.5,2);
Comment your answer!
4 - 0
💻 "When it comes to SQL, which topic do you find the most challenging? 🤔
Options:
🔄 Working with JOINs and Subqueries
🔍 Understanding Window Functions
🏗️ Normalization and Database Design
⚡ Indexing and Query Optimization
🧩 Advanced SQL Functions (e.g., CTEs, Recursive Queries)
If it’s something else not listed here, feel free to drop a comment and let me know! 🗣️
Share your thoughts so I can create more content to help you master it! 👨💻👩💻
3 - 0
📝 Excel Automation Tools for Data Cleaning and Transformation
Hey everyone! 📊
Curious to know your go-to tool for data cleaning and transformation in Excel. Which Excel automation tool do you primarily use?
🔘 A) Power Query
🔘 B) Macro
🔘 C) Does transformations manually
Share your experiences! 👇
#Excel #DataCleaning #Automation #Macros #PowerQuery #DataTransformation
1 - 0
Try solving this ✅ - Practice SQL💻
✅Write a query to print the prime numbers between 1 and 10 ?
Comment your query or logic 👨💻
Hint :- https://youtu.be/2jCOfIU-nkk?si=oG4ZA... (make use of the same technique/logic used in this question)
3 - 0
🔍 Test Your SQL Skills: SQL Challenge!💡
Consider the following table:
O_Id,C_Id,Amount
1,101,200
2,102,300
3,101,150
4,103,400
5,101,250
(O_Id is Order_ID, C_Id is Customer_ID)
Which of the following SQL queries will return the average order amount for each customer, sorted by the average order amount in descending order?
Choose the correct query.
#sql #sqlinterviewquery #dataanalystinterview #dataanalyst
5 - 6
❓SQL Knowledge Check - Test your SQL Knowledge 🖥️💡
What will be the output of the following query ?
--Add 8999 years in the specified date 20240727
DECLARE @num int = 8999;
SELECT DATEADD(year, @num, '20240727');
Comment your answer and why you arrived at the conclusion?🤔
#sqlinterviewquestion #sql #complexsql #dataanalytics #sqlanalytics #dataprojecthub
2 - 0
🎥 New Video Alert!
🔗 Link: https://youtu.be/h3lgWRG3VNk?si=21L2B...
This a very common SQL interview question which is asked in companies like Amazon, Flipkart, BigBasket, Swiggy and similar E-Commerce companies.
🎥 Title: SQL Interview Question | Returning Active Customers | Commonly Asked Interview Question
#sqlinterviewquestions #sqlinterviewquestionandanswers #amazoninterview #flipkartinterview #dataanalyticsinterview #dataanalysis
2 - 0
Test your SQL Knowledge!🖥️💡
❓What type of join is needed when you wish to include rows that do not have matching values?
#sqlinterview #sqlquiz #sql #dataanalytics
2 - 0
Test your SQL Knowledge!🖥️
❓Which of the following statement is TRUE about SQL Injection?
#sqlinterview #sqlquiz #dataanalytics #dataprojecthub
8 - 0
🧑💻 Explaining the data, and analytics concepts I wish I had known earlier!
✌️Have a great day!