2020: Go From Zero To Hero Videos | The Complete Sql Bootcamp

SELECT orders.order_id, customers.customer_name FROM orders INNER JOIN customers ON orders.customer_id = customers.customer_id; Subqueries: A query nested inside another query (in SELECT , FROM , or WHERE ).

SELECT product_name, price FROM products WHERE price > (SELECT AVG(price) FROM products); Temporary named result sets (using WITH ) for cleaner, more readable queries. the complete sql bootcamp 2020: go from zero to hero videos

FUNCTION(column) OVER (PARTITION BY group_column ORDER BY order_column) SELECT orders