SQL Interview Question 223 || #sql #mysql #oracle #interview #shorts #reels #coding @SekharAcademy1

# Question-223:: Write a SQL query to fetch the total sales for each product category.

SELECT pc.category_name, SUM(p.price * o.quantity) AS total_sales
FROM products p
JOIN product_categories pc
ON p.category_id = pc.category_id
JOIN orders o
ON p.product_id = o.product_id
GROUP BY pc.category_name;

--SELECT * FROM product_categories
--SELECT * FROM products
--SELECT * FROM orders
--SekharAcademy1

@SekharAcademy1

#sql
#sqlqueries
#mysql
#oracle
#learning
#interview
#programming
#database
#education
#sqlinterview
#interviewquestions
#quiz
#sqlquiz
#quiztest
#test
#interviewtest
#mcq
#mocktest
#viralvideo
#video #viralshorts
#trending #viralreels
#follow #sqljoins
#join #interviewquery
#leetcode #leetcodesql
#leetcodesolutions #job
#jobs #jobsearch #olympics
#databasequeries
#leetcode #leetcodesolutions
#leetcodesql #coding
#sqlinterviewquestionsandanswers
#sqlforbeginners
#sqlinterviewquestions
#sqlqueryinterviewquestionsandanswers
#interview
#education
#mysql questions asked in interview
#mysql uestionsaskedininterview
#sql tricky interview questions and answers
#sqltrickyinterviewquestionsandanswers
#sql senario interview questions and answers
#sqlsenariointerviewquestionsandanswers
#sql interview videos
#sqlinterviewvideos
#sql interview questions and answers in english
#sqlinterviewquestionsandanswersinenglish
#sql queries for java interview
#sqlqueriesforjavainterview
#interview questions for
#interviewquestionsfor
#sqldatascientiestinterviewquestions
#sql data scientiest interview questions
#top 50 interview questions on sql
#top50interviewquestionsonsql
#dataanalutics
#data
#sql interview questions for testing
#sql interview questions and answers for join
#sqlinterviewquestionsandanswersforjoin
#join in sql
#Joininsql
#functionsinsql

Видео SQL Interview Question 223 || #sql #mysql #oracle #interview #shorts #reels #coding @SekharAcademy1 канала Sekhar Academy