Joins and Windows Function in Sql.

Introduction As a data analyst or Data engineer mastering Sql narrows down to getting into advanced concepts that will enable one to manage, query and optimize databases. In this article we will explore Joins and windows functions in sql. Joins Joins bringing together information from different tables turning a database into a unified space where data relationship becoming the building for effective data analysis Types of joins Inner Join This join combines two or more tables and returns only rows that have matching values in the tables. For example look for an order in the orders table Then customer table The relationship between the two tables is the customer_id.To create an inner join use this; SELECT Orders.order_id , Clients.first_name, Orders.order_date FROM Orders INNER JOIN Clients ON Orders.customer_id=Clients.Customer_id; it will display something like Left Join The left join returns all rows from the left teble and only the matched rows from the right table, if the is no mat