วีดีโอ

sir leetcod ke solution bhi btaoye

sir can you make videos on AWS and ML

Voice is not clear

SELECT E.EMP_NAME, E.EMP_SALARY FROM EMPLOYEE E LEFT JOIN DEPARTMENT D ON E.EMP_DEPTID=D.DEPT_ID WHERE D.DEPT_LOCATION = 'NEW YORK';

SELECT * FROM EMPLOYEE WHERE EMP_DEPTID = (SELECT DEPT_ID FROM DEPARTMENT WHERE DEPT_LOCATION = 'NEW YORK' );

SELECT EMP_ID, EMP_NAME, EMP_SALARY, EMP_DEPID,DEPT_NAME,DEPT_LOCATION FROM (SELECT * FROM EMPLOYEE E LEFT JOIN DEPARTMENT D ON E.EMP_DEPID = D.DEPT_ID WHERE D.DEPT_LOCATION = 'NEW YORK') t; used subquery, join and aliase

I cannot download it on Mac, is there any alternatives?

I would request you to kindly make video on long complex sql query for power bi or tableau requirement ..

Excellent ...I really appreciate the way u explain in simple manner ...I have watch many videos to understand this , but finally my conclusion has been solved with your way of explaining ..I can say no will beat on TH-cam for this ...really appreciated and thank you ...entire series was clearly capture apple to apple ..

C lanvej

Please share data file or CSV file

Please send data file

Hi sir

I ❤ like your vedio apka samjany ka andaz bohat acha ha bhai

hii @Ishwar i tried order by clause in my string values and it doesn't work on string values

Tnx ❤❤❤

15:03 category id ko references nhi kiya apne

SIR IN QUERY 37 CAN WE DO LIKE THIS ? SELECT * FROM vw_RecentOrders ORDER BY OrderDate DESC;

I like your working bro ❤

i see a distorted screen in this video is that same for others?

Bhai, thanks a lot, I was able to solve one SQL problem on hackerrank because of this video.. The blunder on hackerrank on ms SQL ssms Data type Money ❤

Sir very nicely explained. One request- please make tutorial on SSIS.!

sir question 4 (select c.customerID, c.FirstName, c.Lastname, sum(o.totalamount) as Totalamount from customers c join orders o on c.customerID = o.customerID group by c. firstName, c.Lastname order by Total amount desc LIMIT 5:) this is correct query for this question sir

Sir is this project is good for resume?

Can I make this project in snowflake

Video link

isko modify kese ker sakte hai

can you speak loudly, then we can understand the word which you are saying. your voice is very low.

make a video on window functions

Can we use multiple columns in the order by caulse

Web development par bhi videos banao na please apke videos bahut achhe lgte hai

No comments... developers may be understanding 😀😀

Bahut acha laga video

We need in this English language

--Query 5: Retrieve the most popular product category SELECT TOP 1 c.CategoryID,c.CategoryName ,sum(oi.Quantity) as TotalQuantity from OrderItems oi join Products p on oi.ProductID=p.ProductID join Categories c on p.CategoryID=c.CategoryID group by c.CategoryID,c.CategoryName order by TotalQuantity DESC;

--Query 4: List top 5 customers order by total spending SELECT TOP 5 c.CustomerID, CONCAT(c.FirstName, ' ', c.LastName) AS Full_name, SUM(oi.Quantity * oi.Price) AS TotalAmount FROM Orders o JOIN Customers c ON o.CustomerID = c.CustomerID JOIN OrderItems oi ON o.OrderID = oi.OrderID GROUP BY c.CustomerID, c.FirstName, c.LastName ORDER BY TotalAmount DESC;

Thanks brotherw❤❤❤

Real Gem content

Nice explanation sir

please provide database link ?

Thank you sir very nice gide & very nice best explain SQL data type teaching video 👍

sir please make project in oracle sql developer

Nicely explained ! Such a sweet voice you have.

React playlist please

Q16. select p.productID, p.Productname, count(oi.orderID) as OrderCount, Sum(oi.Quantity) As OrderQuantity from products p join OrderItems oi on p.ProductID= oi.ProductID Group by p.productID, p.Productname Order by OrderCount;

❤

Is this applicable on Null values ? Suppose I want to see all records which are NULL using WHERE clause.

Q14- WITH MaxPrices AS ( SELECT p.CategoryID, MAX(p.Price) AS MaxPrice FROM Products p GROUP BY p.CategoryID ) SELECT c.CategoryName, p.ProductName, p.Price FROM MaxPrices mp JOIN Products p ON mp.CategoryID = p.CategoryID AND mp.MaxPrice = p.Price JOIN Categories c ON p.CategoryID = c.CategoryID;

nice

nice