#sqlpractice resultados da pesquisa

Took on “The Blunder” on @hackerrank ... Let’s just say the problem name was accurate 😂 But it helped me learn the REPLACE() function — Small mistake, solid lesson 🙌 #SQLPractice #BuildInPublic #HackerRank #TechTwitter

Avnie0919's tweet image. Took on “The Blunder” on @hackerrank ...
Let’s just say the problem name was accurate 😂
But it helped me learn the REPLACE() function — 
Small mistake, solid lesson 🙌

#SQLPractice #BuildInPublic #HackerRank #TechTwitter
Avnie0919's tweet image. Took on “The Blunder” on @hackerrank ...
Let’s just say the problem name was accurate 😂
But it helped me learn the REPLACE() function — 
Small mistake, solid lesson 🙌

#SQLPractice #BuildInPublic #HackerRank #TechTwitter
Avnie0919's tweet image. Took on “The Blunder” on @hackerrank ...
Let’s just say the problem name was accurate 😂
But it helped me learn the REPLACE() function — 
Small mistake, solid lesson 🙌

#SQLPractice #BuildInPublic #HackerRank #TechTwitter

DAY 47: Here is the solution for #SQLPractice Problem on Day 40

Tai_CK5's tweet image. DAY 47: Here is the solution for #SQLPractice Problem on Day 40

DAY 48: Here is the solution to the #SQLPractice Problem from Day 40.

Tai_CK5's tweet image. DAY 48: Here is the solution to the #SQLPractice Problem from Day 40.

For my first assignment, I imported flat files into SQL (named locations) and practiced writing queries to filter, sort, and group data. Seeing results instantly is so satisfying! @TDataImmersed #SQLPractice #DataSkills

TokedeG's tweet image. For my first assignment, I imported flat files into SQL (named locations) and practiced writing queries to filter, sort, and group data. 

Seeing results instantly is so satisfying! 
@TDataImmersed 
#SQLPractice 
#DataSkills
TokedeG's tweet image. For my first assignment, I imported flat files into SQL (named locations) and practiced writing queries to filter, sort, and group data. 

Seeing results instantly is so satisfying! 
@TDataImmersed 
#SQLPractice 
#DataSkills
TokedeG's tweet image. For my first assignment, I imported flat files into SQL (named locations) and practiced writing queries to filter, sort, and group data. 

Seeing results instantly is so satisfying! 
@TDataImmersed 
#SQLPractice 
#DataSkills
TokedeG's tweet image. For my first assignment, I imported flat files into SQL (named locations) and practiced writing queries to filter, sort, and group data. 

Seeing results instantly is so satisfying! 
@TDataImmersed 
#SQLPractice 
#DataSkills

Hey all! Been offline for a bit, but I’ve kept practicing SQL! It’s tough at first, but with steady effort, I’m still crushing it. 💪 #DataAnalytics #Data #SQLPractice #LearningJourney

Favxander_'s tweet image. Hey all!

Been offline for a bit, but I’ve kept practicing SQL!
It’s tough at first, but with steady effort, I’m still crushing it. 💪 

#DataAnalytics #Data #SQLPractice #LearningJourney
Favxander_'s tweet image. Hey all!

Been offline for a bit, but I’ve kept practicing SQL!
It’s tough at first, but with steady effort, I’m still crushing it. 💪 

#DataAnalytics #Data #SQLPractice #LearningJourney
Favxander_'s tweet image. Hey all!

Been offline for a bit, but I’ve kept practicing SQL!
It’s tough at first, but with steady effort, I’m still crushing it. 💪 

#DataAnalytics #Data #SQLPractice #LearningJourney

Struggling with SQL interviews? Practice is key! LeetCode, HackerInk, and SQLite are fantastic resources. Keep grinding and land that dream job! #SQLPractice #TechCareers #JobHunt


🚀 Day 2 of learning #OracleSQL with SQL*Plus 📌 Practiced inserting NULLs, creating tables, & using Primary Keys 💻 Single table queries on EMP table Loving the progress! 🔥 #Day2 #SQLPractice #100DaysOfCode #BCAStudent #LearnSQL #SQLQueries #DatabaseSkills #TechJourney

Krushnapal_9's tweet image. 🚀 Day 2 of learning #OracleSQL with SQL*Plus
📌 Practiced inserting NULLs, creating tables, & using Primary Keys
💻 Single table queries on EMP table

Loving the progress! 🔥

#Day2 #SQLPractice #100DaysOfCode #BCAStudent #LearnSQL #SQLQueries #DatabaseSkills #TechJourney
Krushnapal_9's tweet image. 🚀 Day 2 of learning #OracleSQL with SQL*Plus
📌 Practiced inserting NULLs, creating tables, & using Primary Keys
💻 Single table queries on EMP table

Loving the progress! 🔥

#Day2 #SQLPractice #100DaysOfCode #BCAStudent #LearnSQL #SQLQueries #DatabaseSkills #TechJourney
Krushnapal_9's tweet image. 🚀 Day 2 of learning #OracleSQL with SQL*Plus
📌 Practiced inserting NULLs, creating tables, & using Primary Keys
💻 Single table queries on EMP table

Loving the progress! 🔥

#Day2 #SQLPractice #100DaysOfCode #BCAStudent #LearnSQL #SQLQueries #DatabaseSkills #TechJourney
Krushnapal_9's tweet image. 🚀 Day 2 of learning #OracleSQL with SQL*Plus
📌 Practiced inserting NULLs, creating tables, & using Primary Keys
💻 Single table queries on EMP table

Loving the progress! 🔥

#Day2 #SQLPractice #100DaysOfCode #BCAStudent #LearnSQL #SQLQueries #DatabaseSkills #TechJourney

⚡️Just me, MySQL Workbench, and a challenge of 50+ SQL questions. Diving deep into subqueries, joins, and schema design. #SQLPractice #MySQL #BuildInPublic #100xDevs #SQLQueries #DatabaseDesign #WebDev #BackendDevelopment #LearningToCode #CodeNewbie #DevJourney #LearnSQL #MySQL

Tabish_khan090's tweet image. ⚡️Just me, MySQL Workbench, and a challenge of 50+ SQL questions.
Diving deep into subqueries, joins, and schema design.

#SQLPractice #MySQL #BuildInPublic #100xDevs #SQLQueries #DatabaseDesign #WebDev #BackendDevelopment #LearningToCode #CodeNewbie #DevJourney #LearnSQL #MySQL

Day 4 of my LeetCode SQL Journey! Today I solved 2 more SQL questions and every query is making me better at thinking logically and writing cleaner code. Consistency is the key, and I’m enjoying the process of improving step by step. #LeetCode #SQLPractice #DataScience

Ashutosh____00's tweet image. Day 4 of my LeetCode SQL Journey!

Today I solved 2 more SQL questions and every query is making me better at thinking logically and writing cleaner code.

Consistency is the key, and I’m enjoying the process of improving step by step.

 #LeetCode #SQLPractice #DataScience
Ashutosh____00's tweet image. Day 4 of my LeetCode SQL Journey!

Today I solved 2 more SQL questions and every query is making me better at thinking logically and writing cleaner code.

Consistency is the key, and I’m enjoying the process of improving step by step.

 #LeetCode #SQLPractice #DataScience

Learn SQL the smart way. Practice > Theory. ✅ mode.com/sql-tutorial – Interactive lessons ✅ stratascratch.com – Interview-style problems ✅ leetcode.com/problemset/dat… – Technical SQL challenges Type ‘SQL PRACTICE’ if you know any of them. #SQLPractice #DataSkills


I’m beyond excited and deeply grateful to the amazing team at @LearnwithWiDa and our facilitator @ibn_wittig for offering this free mentorship. Here’s to more growth and more data wins ahead! #DataAnalytics #SQLPractice #WomenInTech #LearnWithWIDA #GratitudeJourney

kafilat_yekeen's tweet image. I’m beyond excited and deeply grateful to the amazing team at @LearnwithWiDa and our facilitator @ibn_wittig for offering this free mentorship.
Here’s to more growth and more data wins ahead!

#DataAnalytics #SQLPractice #WomenInTech #LearnWithWIDA #GratitudeJourney

MY SOLUTION i will be solving it in two ways: SELECT c.Customer_Name Customer_name, SUM(t.amount) total_amount FROM customers c JOIN transaction t ON c.Customer_id=t.Customer_id WHERE EXTRACT(YEAR FROM t.transaction_date) = '2024' GROUP BY 1; #SQLQuery #SQLPractice

abbytechkie's tweet image. MY SOLUTION
i will be solving it in two ways:

SELECT 
c.Customer_Name Customer_name,
SUM(t.amount) total_amount
FROM customers c
JOIN transaction t
ON c.Customer_id=t.Customer_id
WHERE EXTRACT(YEAR FROM t.transaction_date) = '2024'
GROUP BY 1;

#SQLQuery #SQLPractice

WHERE yearr = '2024'; That's the end Understing the question is very important. It says "total transaction amount for each customer for the current year". -- customer -- SUM(total amount) as total_amount -- year -- join tables together #SQLQuery #SQLPractice

abbytechkie's tweet image. WHERE yearr = '2024';

That's the end 
Understing the question is very important. It says "total transaction amount for each customer for the current year".  
-- customer  
-- SUM(total amount) as total_amount 
-- year  
-- join tables together

#SQLQuery #SQLPractice

"Finally set up PostgreSQL 17 on pgAdmin! Ready to dive deep into queries and sharpen my DBMS skills. Let the SQL grind begin! 🧠💻 #PostgreSQL #pgAdmin #SQLPractice"

0xVENOM_DDOS's tweet image. "Finally set up PostgreSQL 17 on pgAdmin! Ready to dive deep into queries and sharpen my DBMS skills. Let the SQL grind begin! 🧠💻 #PostgreSQL #pgAdmin #SQLPractice"

Took on “The Blunder” on @hackerrank ... Let’s just say the problem name was accurate 😂 But it helped me learn the REPLACE() function — Small mistake, solid lesson 🙌 #SQLPractice #BuildInPublic #HackerRank #TechTwitter

Avnie0919's tweet image. Took on “The Blunder” on @hackerrank ...
Let’s just say the problem name was accurate 😂
But it helped me learn the REPLACE() function — 
Small mistake, solid lesson 🙌

#SQLPractice #BuildInPublic #HackerRank #TechTwitter
Avnie0919's tweet image. Took on “The Blunder” on @hackerrank ...
Let’s just say the problem name was accurate 😂
But it helped me learn the REPLACE() function — 
Small mistake, solid lesson 🙌

#SQLPractice #BuildInPublic #HackerRank #TechTwitter
Avnie0919's tweet image. Took on “The Blunder” on @hackerrank ...
Let’s just say the problem name was accurate 😂
But it helped me learn the REPLACE() function — 
Small mistake, solid lesson 🙌

#SQLPractice #BuildInPublic #HackerRank #TechTwitter

Advanced MySQL Practice — Session 1 🧩 Subqueries Mastery: • Returning Single Value • Returning List of Values 🔜 Next Up: Subqueries with ALL & ANY operators — boost your SQL game! #MySQL #SQLPractice #Subqueries #Database #LearningByDoing GitHub 👇:github.com/kshitijkatore


⚡️Just me, MySQL Workbench, and a challenge of 50+ SQL questions. Diving deep into subqueries, joins, and schema design. #SQLPractice #MySQL #BuildInPublic #100xDevs #SQLQueries #DatabaseDesign #WebDev #BackendDevelopment #LearningToCode #CodeNewbie #DevJourney #LearnSQL #MySQL

Tabish_khan090's tweet image. ⚡️Just me, MySQL Workbench, and a challenge of 50+ SQL questions.
Diving deep into subqueries, joins, and schema design.

#SQLPractice #MySQL #BuildInPublic #100xDevs #SQLQueries #DatabaseDesign #WebDev #BackendDevelopment #LearningToCode #CodeNewbie #DevJourney #LearnSQL #MySQL

Learn SQL the smart way. Practice > Theory. ✅ mode.com/sql-tutorial – Interactive lessons ✅ stratascratch.com – Interview-style problems ✅ leetcode.com/problemset/dat… – Technical SQL challenges Type ‘SQL PRACTICE’ if you know any of them. #SQLPractice #DataSkills


🚀 Day 2 of learning #OracleSQL with SQL*Plus 📌 Practiced inserting NULLs, creating tables, & using Primary Keys 💻 Single table queries on EMP table Loving the progress! 🔥 #Day2 #SQLPractice #100DaysOfCode #BCAStudent #LearnSQL #SQLQueries #DatabaseSkills #TechJourney

Krushnapal_9's tweet image. 🚀 Day 2 of learning #OracleSQL with SQL*Plus
📌 Practiced inserting NULLs, creating tables, & using Primary Keys
💻 Single table queries on EMP table

Loving the progress! 🔥

#Day2 #SQLPractice #100DaysOfCode #BCAStudent #LearnSQL #SQLQueries #DatabaseSkills #TechJourney
Krushnapal_9's tweet image. 🚀 Day 2 of learning #OracleSQL with SQL*Plus
📌 Practiced inserting NULLs, creating tables, & using Primary Keys
💻 Single table queries on EMP table

Loving the progress! 🔥

#Day2 #SQLPractice #100DaysOfCode #BCAStudent #LearnSQL #SQLQueries #DatabaseSkills #TechJourney
Krushnapal_9's tweet image. 🚀 Day 2 of learning #OracleSQL with SQL*Plus
📌 Practiced inserting NULLs, creating tables, & using Primary Keys
💻 Single table queries on EMP table

Loving the progress! 🔥

#Day2 #SQLPractice #100DaysOfCode #BCAStudent #LearnSQL #SQLQueries #DatabaseSkills #TechJourney
Krushnapal_9's tweet image. 🚀 Day 2 of learning #OracleSQL with SQL*Plus
📌 Practiced inserting NULLs, creating tables, & using Primary Keys
💻 Single table queries on EMP table

Loving the progress! 🔥

#Day2 #SQLPractice #100DaysOfCode #BCAStudent #LearnSQL #SQLQueries #DatabaseSkills #TechJourney

✅ Day 2 Filtering data like a pro! 🔍 Today I learned how to use AND, OR, NOT, LIKE, and ORDER BY in Oracle SQL. Data is starting to make sense now! 📈 #Day2 #SQLPractice #DataFiltering #OracleSQL #TechLearning @OracleDatabase


Just finished a hands-on SQL practice session! Worked on filtering data using WHERE, AND, OR, and LIKE. Great way to sharpen query logic with real data scenarios. #SQL #Database #SQLPractice #LearnSQL #DataAnalysis #WebDevelopment #Coding

JadiyappaY20936's tweet image. Just finished a hands-on SQL practice session!
Worked on filtering data using WHERE, AND, OR, and LIKE.
Great way to sharpen query logic with real data scenarios.

#SQL #Database #SQLPractice #LearnSQL #DataAnalysis #WebDevelopment #Coding
JadiyappaY20936's tweet image. Just finished a hands-on SQL practice session!
Worked on filtering data using WHERE, AND, OR, and LIKE.
Great way to sharpen query logic with real data scenarios.

#SQL #Database #SQLPractice #LearnSQL #DataAnalysis #WebDevelopment #Coding
JadiyappaY20936's tweet image. Just finished a hands-on SQL practice session!
Worked on filtering data using WHERE, AND, OR, and LIKE.
Great way to sharpen query logic with real data scenarios.

#SQL #Database #SQLPractice #LearnSQL #DataAnalysis #WebDevelopment #Coding
JadiyappaY20936's tweet image. Just finished a hands-on SQL practice session!
Worked on filtering data using WHERE, AND, OR, and LIKE.
Great way to sharpen query logic with real data scenarios.

#SQL #Database #SQLPractice #LearnSQL #DataAnalysis #WebDevelopment #Coding

Hey all! Been offline for a bit, but I’ve kept practicing SQL! It’s tough at first, but with steady effort, I’m still crushing it. 💪 #DataAnalytics #Data #SQLPractice #LearningJourney

Favxander_'s tweet image. Hey all!

Been offline for a bit, but I’ve kept practicing SQL!
It’s tough at first, but with steady effort, I’m still crushing it. 💪 

#DataAnalytics #Data #SQLPractice #LearningJourney
Favxander_'s tweet image. Hey all!

Been offline for a bit, but I’ve kept practicing SQL!
It’s tough at first, but with steady effort, I’m still crushing it. 💪 

#DataAnalytics #Data #SQLPractice #LearningJourney
Favxander_'s tweet image. Hey all!

Been offline for a bit, but I’ve kept practicing SQL!
It’s tough at first, but with steady effort, I’m still crushing it. 💪 

#DataAnalytics #Data #SQLPractice #LearningJourney

I’m beyond excited and deeply grateful to the amazing team at @LearnwithWiDa and our facilitator @ibn_wittig for offering this free mentorship. Here’s to more growth and more data wins ahead! #DataAnalytics #SQLPractice #WomenInTech #LearnWithWIDA #GratitudeJourney

kafilat_yekeen's tweet image. I’m beyond excited and deeply grateful to the amazing team at @LearnwithWiDa and our facilitator @ibn_wittig for offering this free mentorship.
Here’s to more growth and more data wins ahead!

#DataAnalytics #SQLPractice #WomenInTech #LearnWithWIDA #GratitudeJourney

Took on “The Blunder” on @hackerrank ... Let’s just say the problem name was accurate 😂 But it helped me learn the REPLACE() function — Small mistake, solid lesson 🙌 #SQLPractice #BuildInPublic #HackerRank #TechTwitter

Avnie0919's tweet image. Took on “The Blunder” on @hackerrank ...
Let’s just say the problem name was accurate 😂
But it helped me learn the REPLACE() function — 
Small mistake, solid lesson 🙌

#SQLPractice #BuildInPublic #HackerRank #TechTwitter
Avnie0919's tweet image. Took on “The Blunder” on @hackerrank ...
Let’s just say the problem name was accurate 😂
But it helped me learn the REPLACE() function — 
Small mistake, solid lesson 🙌

#SQLPractice #BuildInPublic #HackerRank #TechTwitter
Avnie0919's tweet image. Took on “The Blunder” on @hackerrank ...
Let’s just say the problem name was accurate 😂
But it helped me learn the REPLACE() function — 
Small mistake, solid lesson 🙌

#SQLPractice #BuildInPublic #HackerRank #TechTwitter

Hey all! Been offline for a bit, but I’ve kept practicing SQL! It’s tough at first, but with steady effort, I’m still crushing it. 💪 #DataAnalytics #Data #SQLPractice #LearningJourney

Favxander_'s tweet image. Hey all!

Been offline for a bit, but I’ve kept practicing SQL!
It’s tough at first, but with steady effort, I’m still crushing it. 💪 

#DataAnalytics #Data #SQLPractice #LearningJourney
Favxander_'s tweet image. Hey all!

Been offline for a bit, but I’ve kept practicing SQL!
It’s tough at first, but with steady effort, I’m still crushing it. 💪 

#DataAnalytics #Data #SQLPractice #LearningJourney
Favxander_'s tweet image. Hey all!

Been offline for a bit, but I’ve kept practicing SQL!
It’s tough at first, but with steady effort, I’m still crushing it. 💪 

#DataAnalytics #Data #SQLPractice #LearningJourney

Dear @popsql I'm unable to access my student account benefits provided by you. I already mailed you the matter @ [email protected] #SQLPractice #DataScience #SQL


For my first assignment, I imported flat files into SQL (named locations) and practiced writing queries to filter, sort, and group data. Seeing results instantly is so satisfying! @TDataImmersed #SQLPractice #DataSkills

TokedeG's tweet image. For my first assignment, I imported flat files into SQL (named locations) and practiced writing queries to filter, sort, and group data. 

Seeing results instantly is so satisfying! 
@TDataImmersed 
#SQLPractice 
#DataSkills
TokedeG's tweet image. For my first assignment, I imported flat files into SQL (named locations) and practiced writing queries to filter, sort, and group data. 

Seeing results instantly is so satisfying! 
@TDataImmersed 
#SQLPractice 
#DataSkills
TokedeG's tweet image. For my first assignment, I imported flat files into SQL (named locations) and practiced writing queries to filter, sort, and group data. 

Seeing results instantly is so satisfying! 
@TDataImmersed 
#SQLPractice 
#DataSkills
TokedeG's tweet image. For my first assignment, I imported flat files into SQL (named locations) and practiced writing queries to filter, sort, and group data. 

Seeing results instantly is so satisfying! 
@TDataImmersed 
#SQLPractice 
#DataSkills

I’m beyond excited and deeply grateful to the amazing team at @LearnwithWiDa and our facilitator @ibn_wittig for offering this free mentorship. Here’s to more growth and more data wins ahead! #DataAnalytics #SQLPractice #WomenInTech #LearnWithWIDA #GratitudeJourney

kafilat_yekeen's tweet image. I’m beyond excited and deeply grateful to the amazing team at @LearnwithWiDa and our facilitator @ibn_wittig for offering this free mentorship.
Here’s to more growth and more data wins ahead!

#DataAnalytics #SQLPractice #WomenInTech #LearnWithWIDA #GratitudeJourney

DAY 47: Here is the solution for #SQLPractice Problem on Day 40

Tai_CK5's tweet image. DAY 47: Here is the solution for #SQLPractice Problem on Day 40

DAY 48: Here is the solution to the #SQLPractice Problem from Day 40.

Tai_CK5's tweet image. DAY 48: Here is the solution to the #SQLPractice Problem from Day 40.

⚡️Just me, MySQL Workbench, and a challenge of 50+ SQL questions. Diving deep into subqueries, joins, and schema design. #SQLPractice #MySQL #BuildInPublic #100xDevs #SQLQueries #DatabaseDesign #WebDev #BackendDevelopment #LearningToCode #CodeNewbie #DevJourney #LearnSQL #MySQL

Tabish_khan090's tweet image. ⚡️Just me, MySQL Workbench, and a challenge of 50+ SQL questions.
Diving deep into subqueries, joins, and schema design.

#SQLPractice #MySQL #BuildInPublic #100xDevs #SQLQueries #DatabaseDesign #WebDev #BackendDevelopment #LearningToCode #CodeNewbie #DevJourney #LearnSQL #MySQL

Day 4 of my LeetCode SQL Journey! Today I solved 2 more SQL questions and every query is making me better at thinking logically and writing cleaner code. Consistency is the key, and I’m enjoying the process of improving step by step. #LeetCode #SQLPractice #DataScience

Ashutosh____00's tweet image. Day 4 of my LeetCode SQL Journey!

Today I solved 2 more SQL questions and every query is making me better at thinking logically and writing cleaner code.

Consistency is the key, and I’m enjoying the process of improving step by step.

 #LeetCode #SQLPractice #DataScience
Ashutosh____00's tweet image. Day 4 of my LeetCode SQL Journey!

Today I solved 2 more SQL questions and every query is making me better at thinking logically and writing cleaner code.

Consistency is the key, and I’m enjoying the process of improving step by step.

 #LeetCode #SQLPractice #DataScience

🚀 Day 2 of learning #OracleSQL with SQL*Plus 📌 Practiced inserting NULLs, creating tables, & using Primary Keys 💻 Single table queries on EMP table Loving the progress! 🔥 #Day2 #SQLPractice #100DaysOfCode #BCAStudent #LearnSQL #SQLQueries #DatabaseSkills #TechJourney

Krushnapal_9's tweet image. 🚀 Day 2 of learning #OracleSQL with SQL*Plus
📌 Practiced inserting NULLs, creating tables, & using Primary Keys
💻 Single table queries on EMP table

Loving the progress! 🔥

#Day2 #SQLPractice #100DaysOfCode #BCAStudent #LearnSQL #SQLQueries #DatabaseSkills #TechJourney
Krushnapal_9's tweet image. 🚀 Day 2 of learning #OracleSQL with SQL*Plus
📌 Practiced inserting NULLs, creating tables, & using Primary Keys
💻 Single table queries on EMP table

Loving the progress! 🔥

#Day2 #SQLPractice #100DaysOfCode #BCAStudent #LearnSQL #SQLQueries #DatabaseSkills #TechJourney
Krushnapal_9's tweet image. 🚀 Day 2 of learning #OracleSQL with SQL*Plus
📌 Practiced inserting NULLs, creating tables, & using Primary Keys
💻 Single table queries on EMP table

Loving the progress! 🔥

#Day2 #SQLPractice #100DaysOfCode #BCAStudent #LearnSQL #SQLQueries #DatabaseSkills #TechJourney
Krushnapal_9's tweet image. 🚀 Day 2 of learning #OracleSQL with SQL*Plus
📌 Practiced inserting NULLs, creating tables, & using Primary Keys
💻 Single table queries on EMP table

Loving the progress! 🔥

#Day2 #SQLPractice #100DaysOfCode #BCAStudent #LearnSQL #SQLQueries #DatabaseSkills #TechJourney

MY SOLUTION i will be solving it in two ways: SELECT c.Customer_Name Customer_name, SUM(t.amount) total_amount FROM customers c JOIN transaction t ON c.Customer_id=t.Customer_id WHERE EXTRACT(YEAR FROM t.transaction_date) = '2024' GROUP BY 1; #SQLQuery #SQLPractice

abbytechkie's tweet image. MY SOLUTION
i will be solving it in two ways:

SELECT 
c.Customer_Name Customer_name,
SUM(t.amount) total_amount
FROM customers c
JOIN transaction t
ON c.Customer_id=t.Customer_id
WHERE EXTRACT(YEAR FROM t.transaction_date) = '2024'
GROUP BY 1;

#SQLQuery #SQLPractice

WHERE yearr = '2024'; That's the end Understing the question is very important. It says "total transaction amount for each customer for the current year". -- customer -- SUM(total amount) as total_amount -- year -- join tables together #SQLQuery #SQLPractice

abbytechkie's tweet image. WHERE yearr = '2024';

That's the end 
Understing the question is very important. It says "total transaction amount for each customer for the current year".  
-- customer  
-- SUM(total amount) as total_amount 
-- year  
-- join tables together

#SQLQuery #SQLPractice

Just finished a hands-on SQL practice session! Worked on filtering data using WHERE, AND, OR, and LIKE. Great way to sharpen query logic with real data scenarios. #SQL #Database #SQLPractice #LearnSQL #DataAnalysis #WebDevelopment #Coding

JadiyappaY20936's tweet image. Just finished a hands-on SQL practice session!
Worked on filtering data using WHERE, AND, OR, and LIKE.
Great way to sharpen query logic with real data scenarios.

#SQL #Database #SQLPractice #LearnSQL #DataAnalysis #WebDevelopment #Coding
JadiyappaY20936's tweet image. Just finished a hands-on SQL practice session!
Worked on filtering data using WHERE, AND, OR, and LIKE.
Great way to sharpen query logic with real data scenarios.

#SQL #Database #SQLPractice #LearnSQL #DataAnalysis #WebDevelopment #Coding
JadiyappaY20936's tweet image. Just finished a hands-on SQL practice session!
Worked on filtering data using WHERE, AND, OR, and LIKE.
Great way to sharpen query logic with real data scenarios.

#SQL #Database #SQLPractice #LearnSQL #DataAnalysis #WebDevelopment #Coding
JadiyappaY20936's tweet image. Just finished a hands-on SQL practice session!
Worked on filtering data using WHERE, AND, OR, and LIKE.
Great way to sharpen query logic with real data scenarios.

#SQL #Database #SQLPractice #LearnSQL #DataAnalysis #WebDevelopment #Coding

SQL Assignments for Beginners - We have over ten years of experience and have completed over a thousand SQL assignments with solutions. udaipurwebdesigner.com/sql-assignment… #UdaipurWebDesigner #SQLLearning #SQLPractice #BeginnerSQL #SQLExercises #DatabaseFundamentals #LearnSQLFromHome

UdaipurWeb's tweet image. SQL Assignments for Beginners - We have over ten years of experience and have completed over a thousand SQL assignments with solutions.
udaipurwebdesigner.com/sql-assignment…
#UdaipurWebDesigner #SQLLearning #SQLPractice #BeginnerSQL #SQLExercises #DatabaseFundamentals #LearnSQLFromHome

Loading...

Something went wrong.


Something went wrong.


United States Trends