Thanks for your videos thus far. If you don't have already, can you do a video explaining the difference/similarity between cte and sub-query(if any) and which one is better?
Helpful, can u please provide script to create tables and data along with all videos?? this will be more helpful to go along with your solutions. Thanks
thanks for the video. can you make the one for beginners, for instance how to get all fridays /sundays/mondays etc. of a year in sql? Thanks in advance🌹. 08.06.2023, 19:58
Hi, I have questions, can you please give the solution for this. We have office data related punch in and punch out data. As a employee we used to go out from office multiple times for tea, snacks etc. We need to find out time duration of a employee in a working day , how much time he was out of office. Table Office: Columns: EmployeeId, starttimeofoffice,endtimeofoffice,punchIn, Punchout
Table A (Student ID, Student Name, Student Age) table B (Student ID, Student Class, Student Section) Select Student Name, Student Class, Student Section where Student Age between 16 to 18 and Student Section is 'D' How to find out Mam ?
@@LearnatKnowstar thanks madam but ek request h ki every step like crystal clear karwayega and why and where we use which type of approach so kindly please make Hindi regarding complex SQL
Hello Mam, I have some questions that were asked in an interview, if possible please make a video on these questions Question: 1 SELECT c.CustomerName, COUNT(o.OrderID) AS NumOrders FROM Customers c LEFT JOIN Orders o ON c.CustomerID = o.CustomerID GROUP BY c.CustomerName HAVING COUNT(o.OrderID) > 10 ORDER BY NumOrders DESC; This query returns the names of all customers who have placed more than 10 orders, along with the number of orders they have placed. However, there is an issue with this query that needs to be resolved. Can you identify the issue with this query and provide a solution to fix it? Question: 2 Here's an example of a SQL query with some issues that need to be resolved: SELECT * FROM Orders WHERE OrderDate >= '2022-01-01' AND OrderDate 1000 ORDER BY o.OrderDate DESC; Can you identify the issue with this query and provide a solution to fix it? Question 4: Consider the following scenario: You are working on a database application that stores sales data for a retail company. The database has two tables: "Sales" and "Products". The "Sales" table contains over 1 million rows and has the following columns: SaleID, ProductID, SaleDate, SaleAmount. The "Products" table contains over 10,000 rows and has the following columns: ProductID, ProductName, ProductCategory, UnitPrice. Write a SQL query that retrieves the total sales amount for each product category for the current year. The query should return the following columns: ProductCategory, TotalSalesAmount. Query should be optimizefor performance also. .
